]
http://gurjeet-tech.blogspot.com/2011/02/pagination-of-results-in-postgres.htmlhttp://gurjeet-tech.blogspot.com/2011/02/pagination-of-results-in-postgres.html
Best regards,
--
Gurjeet Singh
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
On Tue, Dec 28, 2010 at 2:08 AM, kakarukeys kakaruk...@gmail.com 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
On Tue, Dec 28, 2010 at 9:43 AM, Kevin Grittner kevin.gritt...@wicourts.gov
wrote:
Gurjeet Singh singh.gurj...@gmail.com 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 kakaruk...@gmail.com 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,
On Wed, Dec 22, 2010 at 6:28 AM, tuanhoanganh hatua...@gmail.com 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
On Mon, Sep 27, 2010 at 8:50 PM, Dave Crooke dcro...@gmail.com 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,
On Sun, Oct 4, 2009 at 6:32 AM, Robert Haas robertmh...@gmail.com wrote:
On Sat, Oct 3, 2009 at 2:11 AM, S Arvind arvindw...@gmail.com wrote:
Thanks Robert,
So for our scenario what is the most important factor to be
noted
for performance.
Tough to say without benchmarking, but
On Tue, Sep 22, 2009 at 7:35 PM, Stef Telford s...@ummon.com 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
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 matt...@flymine.orgwrote:
It appears that I am being censored. I
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 have a
10 matches
Mail list logo