Jonathan Hedstrom wrote:
Tom Lane wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
Also, schedule some maintenance window for your server to run memtest86
and possibly something to check for bad blocks on your drives.
+1 ... I have not seen any instance of invalid page header that could
Jonathan Hedstrom wrote:
Scott Marlowe wrote:
On Tue, 2007-01-09 at 13:38, Jonathan Hedstrom wrote:
We recently upgraded from 8.1.4 to 8.2.0 on Fedora Core 6, and are now
seeing a few rather ominous-looking messages.
[ SNIP ]
Also, schedule some maintenance window for your server to run
Erick Papadakis wrote:
Right now, if I wish to contribute to the documentation, how do I make
it relevant? Look at MySQL docs, or PHP manual. I can leave comments
in a context-relevant manner -- e.g., check at the bottom of page:
http://sg.php.net/manual/en/ref.pgsql.php.
Have you seen the
Csaba Nagy wrote:
On Tue, 2007-07-24 at 19:06, Stephan Szabo wrote:
Unfortunately I don't think this will work. Multiple backends will happily
pick up the same ctid in their selects and then try to delete the same
records.
I'm pretty sure he said that the batch processing (and the delete)
Lutz Broedel wrote:
Dear list,
I am trying to verify the password given by a user against the system
catalog. Since I need the password hash later on, I can not just use the
authentication mechanism for verification, but need to do this in SQL
statements.
Unfortunately, even if I set
Tom Lane wrote:
chrisj [EMAIL PROTECTED] writes:
This helped a lot, but ideally I want a tab field delimiter and -F '\t' does
not seem to work, any ideas??
I don't think there's any provision for backslash-notation in that
switch; you'd need to type an actual tab character there. Depending
Jonas Henriksen wrote:
explain analyze SELECT max(date_time) FROM data_values;
Goes fast and returns:
In prior postgres versions, the planner could not take advantage of
indexes with max() (nor min()) calculations. A workaround to this was
(given an appropriate index) a query like:
select