Tom Lane wrote:
Mark Mielke <[EMAIL PROTECTED]> writes:
To find records after a certain time, I must do one of:
select * from icpric where audtdate > ? or (audtdate = ? and
audttime > ?)
In recent releases (at least 8.2, don't remember about 8.1), a row
comparison is what you want:
Mark Mielke <[EMAIL PROTECTED]> writes:
> To find records after a certain time, I must do one of:
> select * from icpric where audtdate > ? or (audtdate = ? and
> audttime > ?)
In recent releases (at least 8.2, don't remember about 8.1), a row
comparison is what you want:
WHERE (audd
)
Time: 0.880 ms
Sample execution times:
PCCYBER=# select itemno, audtdate, audttime from icpric where audtdate >
20071207 or (audtdate = 20071207 and audttime > 23434145);
itemno | audtdate | audttime
+--+--
MB-AS-M2-CROSSHAIR | 2007120
Guillaume Cottenceau wrote:
> I have noticed that others (Alvaro, Joshua) suggest to set
> vacuum_cost_delay as low as 10 or 20 ms,
My suggestion is to set it as *high* as 10 or 20 ms. Compared to the
original default of 0ms. This is just because I'm lazy enough not to
have done any measuring o
