Re: [PERFORM] SSD + RAID

I have added documentation about the ATAPI drive flush command, and the typical SSD behavior. --- Greg Smith wrote: > Ron Mayer wrote: > > Bruce Momjian wrote: > > > >> Agreed, thought I thought the problem was that SSDs

Re: [PERFORM] bgwriter, checkpoints, curious (seeing delays)

On Fri, Feb 26, 2010 at 11:49 AM, Jorge Montero wrote: > > Tory M Blue 02/26/10 12:52 PM >>> >>> >>> This is too much. Since you have 300 connections, you will probably swap >>> because of this setting, since each connection may use this much >>> work_mem. The rule of the thumb is to set thi

Re: [PERFORM] bgwriter, checkpoints, curious (seeing delays)

> -Mensaje original- > De: Tory M Blue > > 2010/2/25 Devrim GÜNDÜZ : > > On Thu, 2010-02-25 at 22:12 -0800, Tory M Blue wrote: > >> shared_buffers = 1500MB > > > > Some people tend to increase this to 2.2GB(32-bit) or 4-6 > GB (64 bit), > > if needed. Please note that more shared_buff

Re: [PERFORM] bgwriter, checkpoints, curious (seeing delays)

>>> Tory M Blue 02/26/10 12:52 PM >>> >> >> This is too much. Since you have 300 connections, you will probably swap >> because of this setting, since each connection may use this much >> work_mem. The rule of the thumb is to set this to a lower general value >> (say, 1-2 MB), and set it per-que

Re: [PERFORM] bgwriter, checkpoints, curious (seeing delays)

2010/2/25 Devrim GÜNDÜZ : > On Thu, 2010-02-25 at 23:01 -0800, Tory M Blue wrote: > >> Checkpoint_timeout is the default and that looks like 5 mins (300 >> seconds). And is obviously why I have such a discrepancy between time >> reached and requested. > > If you have a high load, you may want to st

Re: [PERFORM] bgwriter, checkpoints, curious (seeing delays)

2010/2/25 Devrim GÜNDÜZ : > On Thu, 2010-02-25 at 22:12 -0800, Tory M Blue wrote: >> shared_buffers = 1500MB > > Some people tend to increase this to 2.2GB(32-bit) or 4-6 GB (64 bit), > if needed. Please note that more shared_buffers will lead to more > pressure on bgwriter, but it also has lots of

Re: [PERFORM] bgwriter, checkpoints, curious (seeing delays)

On Feb 26, 2010, at 11:23 AM, Tory M Blue wrote: > On Fri, Feb 26, 2010 at 5:09 AM, Kevin Grittner > wrote: >> Tory M Blue wrote: >> >>> 2010-02-25 22:53:13 PST LOG: checkpoint starting: time >>> 2010-02-25 22:53:17 PST postgres postgres [local] LOG: unexpected >>> EOF on client connection >>>

Re: [PERFORM] bgwriter, checkpoints, curious (seeing delays)

On Fri, Feb 26, 2010 at 5:09 AM, Kevin Grittner wrote: > Tory M Blue  wrote: > >> 2010-02-25 22:53:13 PST LOG: checkpoint starting: time >> 2010-02-25 22:53:17 PST postgres postgres [local] LOG: unexpected >> EOF on client connection >> 2010-02-25 22:55:43 PST LOG: checkpoint complete: wrote 34155

Re: [PERFORM] Multiple data base on same server

elias ghanem escribió: Hi, I’m using postgresql 8.4 I need to install multiple postgresql dbs on one server but I have some questions: -Is there any problems (performance wise or other) if I have 10 to 15 DBs on the same server? -Each DB needs 10 tablespaces, so if I create 10 different

Re: [PERFORM] Multiple data base on same server

Ok thanks guys for your time -Original Message- From: Craig James [mailto:craig_ja...@emolecules.com] Sent: Friday, February 26, 2010 4:34 PM To: Richard Huxton Cc: elias ghanem; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Multiple data base on same server Richard Huxton wrot

Re: [PERFORM] Multiple data base on same server

Richard Huxton wrote: On 26/02/10 12:45, elias ghanem wrote: Hi, Thanks for your answer, Concerning the second point, each db have different table that are logically related (for ex, tables for configuration, tables for business...) plus I'm planning to put the indexes on their own tablespace

Re: [PERFORM] Multiple data base on same server

Hi, Thanks for your answer, Concerning the second point, each db have different table that are logically related (for ex, tables for configuration, tables for business...) plus I'm planning to put the indexes on their own tablespaces. Concerning the disks I will maybe stored on multiple disks (but

Re: [PERFORM] bgwriter, checkpoints, curious (seeing delays)

Tory M Blue wrote: > 2010-02-25 22:53:13 PST LOG: checkpoint starting: time > 2010-02-25 22:53:17 PST postgres postgres [local] LOG: unexpected > EOF on client connection > 2010-02-25 22:55:43 PST LOG: checkpoint complete: wrote 34155 > buffers (17.8%); 0 transaction log file(s) added, 0 removed

Re: [PERFORM] Multiple data base on same server

On 26/02/10 12:45, elias ghanem wrote: Hi, Thanks for your answer, Concerning the second point, each db have different table that are logically related (for ex, tables for configuration, tables for business...) plus I'm planning to put the indexes on their own tablespaces. Concerning the disks I

Re: [PERFORM] Multiple data base on same server

On 26/02/10 09:37, elias ghanem wrote: Hi, I'm using postgresql 8.4 I need to install multiple postgresql dbs on one server but I have some questions: -Is there any problems (performance wise or other) if I have 10 to 15 DBs on the same server? Clearly that's going to depend on what they're

[PERFORM] Multiple data base on same server

Hi, I'm using postgresql 8.4 I need to install multiple postgresql dbs on one server but I have some questions: -Is there any problems (performance wise or other) if I have 10 to 15 DBs on the same server? -Each DB needs 10 tablespaces, so if I create 10 different tablespaces for each DB I will

Re: [PERFORM] bgwriter, checkpoints, curious (seeing delays)

Tory M Blue wrote: 2010-02-25 22:10:41 PSTLOG: checkpoint complete: wrote 44503 buffers (23.2%); 0 transaction log file(s) added, 0 removed, 20 recycled; write=148.539 s, sync=0.000 s, total=148.540 s This one is typical for your list so I'll only comment on it. This is writing out 350M