No, I didn't, I'm just courious.
Regards,
Zlatko
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Sunday, July 22, 2007 5:41 AM
Subject: Re: [GENERAL] encodings
On Sat, Jul 21, 2007 at 10:24:38PM
On Saturday 21 July 2007 08:00:11 Tom Lane wrote:
Josh Tolley [EMAIL PROTECTED] writes:
Might it just be that the original UNIQUE + NOT NULL index was
bloated or otherwise degraded, and reindexing it would have
resulted in the same performance gain? That's just a guess.
Yeah. There is
--- Original Message ---
From: Mitchell Vincent [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: 20/07/07, 23:24:03
Subject: [GENERAL] PGInstaller Project
This project is of great interest to me as I am looking for a
easier-to-deploy database server and I've always loved
Alvaro Herrera skrev:
Nis Jørgensen wrote:
What if, for instance, I want to render a list of shapes?
To render the shape, I need to get its data, to get its data, I
need to know what type it is. ISTM that the easiest way to achieve
this is storing the type info at the top of the table
Well, what about using inheritence and relation identifiers?
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
On Tue, Jul 17, 2007 at 09:46:42AM -0700, GPS Blaster wrote:
Hi! New to postgres, im trying to import shapefiles into postgres 8.2
using shp2pgsql but so far have failed.
What have you tried and how did it fail?
You might get more help using PostGIS on postgis-users.
Nis Jørgensen wrote:
Alvaro Herrera skrev:
Nis Jørgensen wrote:
What if, for instance, I want to render a list of shapes?
To render the shape, I need to get its data, to get its data, I
need to know what type it is. ISTM that the easiest way to achieve
this is storing the type
Vincenzo Romano [EMAIL PROTECTED] writes:
In the original setup, the UNIQUE constraint had been dropped
*before* doing the tests. So the slow case is without the UNIQUE
constraint but with an index. The NOT NULL was instead there.
With what index, pray tell?
regards,
On 7/22/07, Tom Lane [EMAIL PROTECTED] wrote:
Shreya Bhargava [EMAIL PROTECTED] writes:
1. gdb postgres
2. set args -D test (test is my dbcluster)
3. b hashbuild(this is the function i want to break on)
4. run
You've set the breakpoint in the postmaster process. It won't propagate
to child
On 7/22/07, Sibte Abbas [EMAIL PROTECTED] wrote:
On 7/22/07, Tom Lane [EMAIL PROTECTED] wrote:
Shreya Bhargava [EMAIL PROTECTED] writes:
1. gdb postgres
2. set args -D test (test is my dbcluster)
3. b hashbuild(this is the function i want to break on)
4. run
You've set the breakpoint
On Sunday 22 July 2007 19:20:08 Tom Lane wrote:
Vincenzo Romano [EMAIL PROTECTED] writes:
In the original setup, the UNIQUE constraint had been dropped
*before* doing the tests. So the slow case is without the
UNIQUE constraint but with an index. The NOT NULL was instead
there.
With
Vincenzo Romano [EMAIL PROTECTED] writes:
On Sunday 22 July 2007 19:20:08 Tom Lane wrote:
With what index, pray tell?
In the original setup, the UNIQUE constraint had been dropped
*before* doing the tests. So the slow case is without the
UNIQUE constraint but with an index on NOT NULL
Thanks very much for the suggestions! will try them out
regards,
Shreya
Sibte Abbas [EMAIL PROTECTED] wrote:
On 7/22/07, Sibte Abbas wrote:
On 7/22/07, Tom Lane wrote:
Shreya Bhargava writes:
1. gdb postgres
2. set args -D test (test is my dbcluster)
3. b hashbuild(this
On Jul 22, 2007, at 10:35 AM, Alvaro Herrera wrote:
Nis Jørgensen wrote:
Alvaro Herrera skrev:
Nis Jørgensen wrote:
What if, for instance, I want to render a list of shapes?
To render the shape, I need to get its data, to get its data, I
need to know what type it is. ISTM that the easiest
You might want to look at pgBouncer to pool your drupal pgsql needs. I've
found with 2000 needed connections, I can pool out to only 30 backends and
still push 8k transactions per second.
On 7/21/07, Arnaldo Gandol [EMAIL PROTECTED] wrote:
I have a drupal site working with postgres that
15 matches
Mail list logo