UFS Logging on Solaris 8

On Thu, May 22, 2003 at 05:19:33PM -0300, Fernando Papa wrote:

1) Do you have any experience/problems with this filesystem?

No.

2) performance could be better than "plain" UFS?

Not really, and it may be slower.

3) We have 4 physical 18GB Disk. We are thinking about the layout: One
physiscal disk for O.S. and the other disk for Database. And the two
other disks will be mirror (with DiskSuite). This could be good for
start?

One for OS, "one for Database" as in the binary? Put the binary on
the OS's disk. Put WAL on its own disk (or at least, on a different
disk than the data storage areas). The performance is much better
that way.

I know, solaris is not the best platform to run postgresql, but I'ts the
only we have now.

Some people report that Linux is actually faster than Solaris on the
various SPARCs. I have my doubts, but I haven't tried.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

Hi,

I need to output a Y or N depending on a count being greater than 0 or not.
I think I've seen a co-worker at a pervious job do something like this, but
I am unable to find any examples on the list or in the docs.

Here's my query:

SELECT a.col, COUNT(DISTINCT b.col) AS col_count
FROM table1 a
LEFT OUTER JOIN table2 b
ON a.col=b.col
GROUP BY a.col

So what I'm looking for is col_count to contain a Y if the count is greater
than 0, else an N.

Anyone know how to do this?

Thanks,
Cameron

You want case:

select a,
case
when a=0 then 'Y'
else 'N'
end
from test;

On Fri, 23 May 2003, Cameron B. Prince wrote:

On Fri, May 23, 2003 at 03:06:13PM -0500, Cameron B. Prince wrote:

Hi,

I need to output a Y or N depending on a count being greater than 0 or not.
I think I've seen a co-worker at a pervious job do something like this, but
I am unable to find any examples on the list or in the docs.

Use a CASE statement:

CASE WHEN COUNT(DISTINCT b.col) = 0 THEN 'N' ELSE 'Y' END

Here's my query:

SELECT a.col, COUNT(DISTINCT b.col) AS col_count
FROM table1 a
LEFT OUTER JOIN table2 b
ON a.col=b.col
GROUP BY a.col

So what I'm looking for is col_count to contain a Y if the count is greater
than 0, else an N.

Anyone know how to do this?

--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/