Check out pgFouine.
Sent from my iPhone
On Jun 15, 2008, at 10:41 AM, "Uwe Bartels" <[EMAIL PROTECTED]>
wrote:
Hi Alexander,
thanks for you answer.
What you wrote in terms of postgres I knew. I just tested to log all
statements with statistics. This is a lot of unstructured data in a
l
On Wed, Apr 16, 2008 at 4:39 PM, Joshua D. Drake <[EMAIL PROTECTED]>
wrote:
> On Wed, 16 Apr 2008 13:37:32 -0700
> "Jeffrey Baker" <[EMAIL PROTECTED]> wrote:
>
> > > I can second this. The MSA 70 is a great unit for the money.
> >
> > Thank you both. The MSA 70 looks like an ordinary disk shelf.
Might want to check out the HP MSA70 arrays. I've had better luck with them
and you can get 25 drives in a smaller rack unit size. I had a bad
experience with the MD3000 and now only buy MD1000's with Perc 6/e when I
buy Dell.
Good luck!
On Wed, Apr 16, 2008 at 4:15 PM, Jeffrey Baker <[EMAIL PRO
nalyze function
internals ;-)
Gavin
On Wed, Apr 16, 2008 at 11:09 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Gavin M. Roy" <[EMAIL PROTECTED]> writes:
> > In 8.3.0, I'm seeing some oddities with SQL functions which I thought
> were
> > immune to the p
In 8.3.0, I'm seeing some oddities with SQL functions which I thought were
immune to the planner data restrictions of plpgsql functions and the sort.
Basically I have a query which executes in 5ms but when wrapped in a SQL
function, takes 500ms. I've checked all the types passed in to make sure
t
How many backends do you have at any given time? Have you tried using
something like pgBouncer to lower backend usage? How about your IO
situation? Have you run something like sysstat to see what iowait is
at?
On 9/11/07, Ruben Rubio <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE---
Having done something similar recently, I would recommend that you look at
adding connection pooling using pgBouncer transaction pooling between your
benchmark app and PgSQL. In our application we have about 2000 clients
funneling down to 30 backends and are able to sustain large transaction per
the data. That being said, I think
Tom's reply on what to journal and not to journal should really put
an end to this side of the conversation.
Gavin
On Dec 1, 2005, at 10:49 AM, Gavin M. Roy wrote:
Here's a fairly recent post on reiserfs (and performance):
http://archives.po
her in
On Dec 1, 2005, at 10:40 AM, Tino Wildenhain wrote:
Am Donnerstag, den 01.12.2005, 10:07 -0800 schrieb Gavin M. Roy:
Hi Michael,
I'm a fan of ReiserFS, and I can be wrong, but I believe using a
journaling filesystem for the PgSQL database could be slowing things
down.
Have a 200
h it would probably help to split the directory
up using tablespaces.
But thanks for the suggestion!
---(end of
broadcast)---
TIP 5: don't forget to increase your free space map settings
Gavin M. Roy
800 Pound Gorilla
[
What stood out to me the most was:On Sep 22, 2005, at 2:20 PM, Jean-Pierre Pelletier wrote: -> Seq Scan on price p (cost=0.00..11317.75 rows=581475 width=4) a) is the index there, b) have you analyzed, c) perhaps the planners have different default values for when to use an index vrs a seqscan..
Please wait a week before buying Sun v20z's or v40z's from off of Ebay
(j/k). (As I'm in the process of picking up a few) From everything I
hear the v20z/v40z's are a great way to go and I'll know more in 15 days
or so.
Regards,
Gavin
Steve Poe wrote:
IBM, Sun and HP have their fairly pricey O
Is the from field nullable? If not, try "create index calllogs_from on
calllogs ( from );" and then do an explain analyze of your query.
Gavin
Chris Cheston wrote:
ok i just vacuumed it and it's taking slightly longer now to execute
(only about 8 ms longer, to around 701 ms).
Not using indexes f
It might be helpful to include a sample query that is running slower
than you expect, with the table structure, and the output of explain
{query}.
Gavin
Leon Out wrote:
Hello all. I am in the midst of porting a large web application from a
MS SQL Server backend to PostgreSQL. The migration work
I am searching for best pg distro to run pg (7.4.1).
This is generally based upon opinion. Honestly though, your kernel
version is more important for performance than the distro. Personally I
use gentoo, love gentoo, and would recommend very few other distros
(Slackware) for servers. RedH
Might want to look at metalog, it does delayed writes, though ultimately
your issue is io bound and there's not much you can do to reduce io if
you want to keep syslog logging your pgsql queries and such.
Tom Lane wrote:
Greg Spiegelberg <[EMAIL PROTECTED]> writes:
I turned syslog back on an
16 matches
Mail list logo
