[PERFORM] Using high speed swap to improve performance?

Hi there,   About a year ago we setup a machine with sixteen 15k disk spindles on Solaris using ZFS. Now that Oracle has taken Sun, and is closing up Solaris, we want to move away (we are more familiar with Linux anyway).   So the plan is to move to Linux and put the data on a SAN using

Re: [PERFORM] Using high speed swap to improve performance?

What about FreeBSD with ZFS? I have no idea which features they support and which not, but it at least is a bit more free than Solaris and still offers that very nice file system. Best regards, Arjen On 2-4-2010 21:15 Christiaan Willemsen wrote: Hi there, About a year ago we setup a

Re: [PERFORM] How much memory is PostgreSQL using

Greg, Thanks for your help. 1) How does the number of buffers provided by pg_buffercache compare to memory (buffers * X = Y meg)? 2) Is there a way to tell how many total buffers I have available/max? Thanks, Lance Campbell Software Architect/DBA/Project Manager Web Services at Public Affairs

[PERFORM] Does the psql executable support a fetch many approach when dumping large queries to stdout?

Does the psql executable have any ability to do a fetch many, using a server-side named cursor, when returning results? It seems like it tries to retrieve the query entirely to local memory before printing to standard out. Specifically, I've tried running the following command on my desktop,

Re: *** PROBABLY SPAM *** [PERFORM] Does the psql executable support a fetch many approach when dumping large queries to stdout?

Does the psql executable have any ability to do a fetch many, using a server-side named cursor, when returning results? It seems like it tries to retrieve the query entirely to local memory before printing to standard out. I think it grabs the whole result set to calculate the display

Re: [PERFORM] Does the psql executable support a fetch many approach when dumping large queries to stdout?

Ah, you're right. Thanks Hannu, that's a good solution. Hannu Krosing wrote: On Fri, 2010-04-02 at 16:28 -0400, Beaver, John E wrote: ... I know that the query used here could have been a COPY statement, which I assume would be better-behaved, but I'm more concerned about the

Re: *** PROBABLY SPAM *** [PERFORM] Does the psql executable support a fetch many approach when dumping large queries to stdout?

That makes sense. I'll just use a COPY statement instead like Hannu suggests. Pierre C wrote: Does the psql executable have any ability to do a "fetch many", using a server-side named cursor, when returning results? It seems like it tries to retrieve the query entirely to local

[PERFORM] David Crooke wants to stay in touch on LinkedIn

LinkedIn David Crooke requested to add you as a connection on LinkedIn: -- Dimi, I'd like to add you to my professional network on LinkedIn. - David Crooke Accept invitation from David Crooke