[PERFORM] postgresql and syslog

Hi, I am using postgresql 8.3 with FreeBSD. FreeBSD is using syslog by default for postgresql logs. I would like to disable syslog in postgresql.conf. Does this change increase the performance? What is the impact of using syslog on postgresql performance? Thanks. -- Sent via pgsql-performance m

Re: [PERFORM] cluster index on a table

table in the cluster > order however. > > > On 7/15/09 8:04 AM, "Ibrahim Harrani" wrote: > > Hi, > > thanks for your suggestion. > Is there any benefit of setting fillfactor to 70 or 80 on this table? > > > > On Wed, Jun 24, 2009 at 8:42 PM, Scott Marlowe

Re: [PERFORM] cluster index on a table

Hi, thanks for your suggestion. Is there any benefit of setting fillfactor to 70 or 80 on this table? On Wed, Jun 24, 2009 at 8:42 PM, Scott Marlowe wrote: > As another poster pointed out, you cluster on ONE index and one index > only.  However, you can cluster on a multi-column index. > -- S

[PERFORM] cluster index on a table

Hello, I have a table like following. To increase the performance of this table, I would like to create CLUSTER. First, Which index should I use on this table for CLUSTER? Secondly, Can I create multiple CLUSTER on the same table? I will appreciate, if you can suggest other options to increase

Re: [PERFORM] postgresql 8.3 tps rate

at 12:44 AM, Craig James wrote: > David Rees wrote: >> >> On Thu, Jan 22, 2009 at 1:27 PM, Ibrahim Harrani >> wrote: >>> >>> Version 1.93d --Sequential Output-- --Sequential Input- >>> --Random- >>> Concurrency 1 -Per

Re: [PERFORM] postgresql 8.3 tps rate

pport/motherboards/server/sb/CS-021019.htm On Thu, Jan 22, 2009 at 11:41 PM, David Rees wrote: > On Thu, Jan 22, 2009 at 1:27 PM, Ibrahim Harrani > wrote: >> Version 1.93d --Sequential Output-- --Sequential Input- >> --Random- >> Concurrency 1 -Per Chr-

Re: [PERFORM] postgresql 8.3 tps rate

version of bonnie++ Thanks in advance. On Thu, Jan 22, 2009 at 7:14 PM, Merlin Moncure wrote: > On 1/22/09, Ibrahim Harrani wrote: >> >> Is this rate is normal or not? What can I do to improve tps and insert >> performance? >> >> postgresql.c

Re: [PERFORM] postgresql 8.3 tps rate

14 PM, Merlin Moncure wrote: > On 1/22/09, Ibrahim Harrani wrote: >> >> Is this rate is normal or not? What can I do to improve tps and insert >> performance? >> >> postgresql.conf >> >> shared_buffers = 800MB # mi

[PERFORM] postgresql 8.3 tps rate

Hi, I am running postgresql 8.3.5 on FreeBSD with Dual core Intel(R) Xeon(R) CPU 3065 @ 2.33GHz, 2GB RAM and Seagate Technology - Barracuda 7200.10 SATA 3.0Gb/ (RAID 1). I made several benchmark test with pgbench, TPS rate is almost 40 +/- 5. $ pgbench -i pgbench -s 50 -U pgsql [pg...@$ pgbench