The following bug has been logged online:
Bug reference: 6139
Logged by: Hitoshi Harada
Email address: umi.tan...@gmail.com
PostgreSQL version: 8.2+
Operating system: Any
Description:LIMIT doesn't return correct result when the value is
huge
Details:
db1=# select co
On 1/08/2011 6:35 PM, Alex Dragojlovic wrote:
The following bug has been logged online:
Bug reference: 6138
Logged by: Alex Dragojlovic
Email address: aleksandar.dragojlo...@gmail.com
PostgreSQL version: 8.4
Operating system: OSX Lion
Description:Install failed
Detai
The following bug has been logged online:
Bug reference: 6138
Logged by: Alex Dragojlovic
Email address: aleksandar.dragojlo...@gmail.com
PostgreSQL version: 8.4
Operating system: OSX Lion
Description:Install failed
Details:
I cannot install PostgreSql on my laptop
Hi.
My simple testcase is:
> Testcase may be as simple as:
>
> CREATE TABLESPACE tblsp_ix LOCATION '/some_dedicated_hdd'
>
> CREATE TABLE tp_req
> (
>id bigint PRIMARY KEY USING INDEX TABLESPACE tblsp_ix,
>arrived timestamp NOT NULL,
>real_ip inet,
>tp_id integer NOT NULL,
>ac
--On 23. März 2011 20:37:11 + Simon Riggs wrote:
The patches are slightly different because the infrastructure isn't
all there in 8.4.
Please can you test these before I commit to 8.4.
Hi Simon,
I've searched the committers mailinglist wether this is already committed, but
either i'v
Hi,
What happens if you drop other indices with a similar size before starting the
copy? It might just be the additional io-load (causing more checkpoints, more
random io, etc) is causing the problems.
Could you share your config and hw info?
Greetings,
Andres
--
Sent via pgsql-bugs mailing
On Mon, Aug 1, 2011 at 8:25 AM, simon wrote:
> Could be that its storing the wrong kind of plan on the RI trigger for PK.
No, not that. Will look elsewhere.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pg
On Sun, Jul 31, 2011 at 2:47 PM, Robert wrote:
> I've found strange behavior of my pg installation (tested both 8.4 and 9.0 -
> they behave same) on FreeBSD platform.
> In short - when some table have PK on bigint field - COPY to that table from
> file becomes slower and slower as table grows. Wh
