The answer may or many not be very postgres specific but...what are some
possible routes that I could take to allows users to upload data from excel
into a postgres via a website? I've never tried anything like this before.
Are there standard modules that might help with this or will I have to
cre
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 do
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 w
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 h
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
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
> > the
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
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
t
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?
re
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 s
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.
http://postgis.refractio
Well, what about using inheritence and relation identifiers?
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
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
> --- 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 a
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.
No, I didn't, I'm just courious.
Regards,
Zlatko
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Zlatko Matić" <[EMAIL PROTECTED]>
Cc:
Sent: Sunday, July 22, 2007 5:41 AM
Subject: Re: [GENERAL] encodings
On Sat, Jul 21, 2007 at 10:24:38PM +0200, Zlatko Matić wrot
16 matches
Mail list logo
