Maybe a wrong mailinglist to ask this, but...
Are there any plans on writing a chapter in the documentation about the implementation
of indices. I know from M$ SQL Server that it is no picnic determining which indices
are useful, and thick books can be written on how to make the right indices f
Something like this oughtta work (not tested)
SELECT a_nr,
(SELECT count(*) FROM cylinders WHERE z_a_nr = a_nr) AS #cylinder,
(SELECT count(*) FROM cylinders WHERE z_a_nr = a_nr AND z_status = 'zdr') AS #zdr,
(SELECT count(*) FROM cylinders WHERE z_a_nr = a_nr AND z_status = 'zcu') AS #zcu,
(SEL
Is there anywhere I can find some benchmark test for postgres. The reason is that I
want to use it for a site that could have several simultanous users querying the
database and I want to be sure that it is stable (and fast) enough to handle that kind
of (ab)use.
Also which is fastest ?
1. A