Re: [GENERAL] Restoring database from old DATA folder

for listen_addresses and set it to '*'. If the database doesn't start, I strongly suggest you look in the log for the error messages and report them verbatim to the list. -- Patrick TJ McPhee North York Canada [EMAIL PROTECTED] ---(end of broadcast)

[GENERAL] Deathly slow performance on SMP red-hat system

load 80 gigs of data in a reasonable amount of time, but individual queries are taking a long time. I'm wondering if anyone's seen anything like this. -- Patrick TJ McPhee North York Canada [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9:

Re: [GENERAL] Deathly slow performance on SMP red-hat system

In article <[EMAIL PROTECTED]>, Joshua D. Drake <[EMAIL PROTECTED]> wrote: % Patrick TJ McPhee wrote: [...] [the query is "select 1"] % > But if I turn on duration logging, I get timings like % > LOG: duration: 91.480 ms [...] % Vacuum? Analyze? I had autovacuum

Re: [GENERAL] Record creation date

saction wrap-around (or that you ran vacuum freeze). Otherwise, the xmin can be compared to the xmin of some table with a timestamp to get the approximate time the record was last changed. -- Patrick TJ McPhee North York Canada [EMAIL PROTECTED] ---(end

Re: [GENERAL] Deathly slow performance on SMP red-hat system

ed the full round trip and found it was taking on the order of 200ms, which is consistent with no time at all to perform the select, but 100ms each to send the query to the db and the result to the client. I think I need to checkout the socket layer on this machine. -- Patrick TJ McPhee North Y

<    1   2