On Mon, Sep 27, 2010 at 8:50 PM, Dave Crooke wrote:
>
> Our Java application manages its own schema. Some of this is from
> Hibernate, but some is hand-crafted JDBC.
>
> By way of an upgrade path, we have a few places where we have added
> additional indexes to optimize performance, and so at sta
On Wed, Dec 22, 2010 at 6:28 AM, tuanhoanganh wrote:
> As far as i know, Pgbouncer can help to minimum connect to postgresql, I
> want tool can open and keep 200 connect to postgresql (be cause start new
> connect to postgresql in windows very slow, i want it open 200 connect in
> first time and
On Tue, Dec 28, 2010 at 2:08 AM, kakarukeys wrote:
> I have a table "aaa" which is not very big. It has less than 10'000
> rows. However read operations on this table is very frequent.
>
> Whenever I try to create a new table "bbb" with foreign key pointing
> to "aaa". The operation locks, and re
On Tue, Dec 28, 2010 at 9:43 AM, Kevin Grittner wrote:
> Gurjeet Singh wrote:
>
> > how many rows does "bbb" have? And what are the data types of
> > column aaa.idand bbb.topic_id?
>
> For that matter, is there a unique index (directly or as the result
>
On Tue, Dec 28, 2010 at 8:55 AM, kakarukeys wrote:
>
> > How long did you wait?
> hours in the past.
> For recent happenings, I aborted after 10 mins.
>
> Since it's a new table's creation, 'bbb' is empty.
> The 'alter table' never finished, so the lock was not released.
> aaa.id, bbb.topic_id ar
On Sun, Aug 17, 2008 at 7:06 AM, Rodrigo E. De León Plicet <
[EMAIL PROTECTED]> wrote:
> On Fri, Aug 15, 2008 at 1:36 PM, Madison Kelly <[EMAIL PROTECTED]> wrote:
> > The 'cust_id' references the customer that the given data belongs to.
> The
> > reason for this "data bucket" (does this structure
There is a limit on the size of the mail that you can send to different
mailing lists. Please try to remove/link your attachments if you are trying
to send any.
Best regards,
On Wed, Jun 10, 2009 at 6:42 PM, Matthew Wakeling wrote:
>
> It appears that I am being censored. I have tried three time
On Tue, Sep 22, 2009 at 7:35 PM, Stef Telford wrote:
> Hey Everyone,
> So, I have a nice postgreSQL server (8.4) up and running our database. I
> even managed to get master->slave going without trouble using the excellent
> skytools.. however, I want to maximize speed and the hot updates where
On Sun, Oct 4, 2009 at 6:32 AM, Robert Haas wrote:
> On Sat, Oct 3, 2009 at 2:11 AM, S Arvind wrote:
> > Thanks Robert,
> > So for our scenario what is the most important factor to be
> noted
> > for performance.
>
> Tough to say without benchmarking, but if you have a lot of small
> da
ns in comments to use CTE
provided even better performance.
[1]
http://gurjeet-tech.blogspot.com/2011/02/pagination-of-results-in-postgres.html<http://gurjeet-tech.blogspot.com/2011/02/pagination-of-results-in-postgres.html>
Best regards,
--
Gurjeet Singh
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
10 matches
Mail list logo
