>> I added the following to FreeBSD:
>>
>> /etc/newsyslog.conf:
>> /var/log/postgresql 600 7 *@T00 JC
make new file?
>> /etc/syslog.conf:
>> local0.*/var/log/postgresql
>>
>> /usr/local/pgsql/data/postgresql.conf:
>> log_destina
Jeff Frost <[EMAIL PROTECTED]> writes:
> I have two postgresql servers. One runs 8.3.1, the other 8.3.3. On the
> 8.3.1
> machine, the index scans are being planned extremely low cost:
> Index Scan using ix_email_entity_thread on email_entity (cost=0.00..4.59
> rows=1 width=1031) (actual t
The "fast" server makes a much more accurate estimation of the number
of rows to expect (4 rows are returning, 1 was estimated). The "slow"
server estimates 1151 rows. Try running ANALYZE on the slow one
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes
On Fri, 18 Jul 2008, Dennis Brakhane wrote:
The "fast" server makes a much more accurate estimation of the number
of rows to expect (4 rows are returning, 1 was estimated). The "slow"
server estimates 1151 rows. Try running ANALYZE on the slow one
You're quite right. I probably didn't mention
I have two postgresql servers. One runs 8.3.1, the other 8.3.3. On the 8.3.1
machine, the index scans are being planned extremely low cost:
explain ANALYZE select * from email_entity where email_thread = 375629157;
QUERY PLAN
-
On Thu, 17 Jul 2008, Claus Guttesen wrote:
After setting log_statement='all' at postgres.conf,
then i'm rebooting OS [freeBSD or CentOS],
i can't find where log file created from log_statement='all' located...
FYI, location of postgres.conf at /var/lib/pgsql/data/postgres.conf
many thanks..
I
> After setting log_statement='all' at postgres.conf,
> then i'm rebooting OS [freeBSD or CentOS],
> i can't find where log file created from log_statement='all' located...
> FYI, location of postgres.conf at /var/lib/pgsql/data/postgres.conf
>
> many thanks..
I added the following to FreeBSD:
/e
Dear all,
After setting log_statement='all' at postgres.conf,
then i'm rebooting OS [freeBSD or CentOS],
i can't find where log file created from log_statement='all' located...
FYI, location of postgres.conf at /var/lib/pgsql/data/postgres.conf
many thanks..
Regards,
Joko [SYSTEM]
PT. Indra Jaya
