Search Postgresql Archives

Re: Strange problem with create table as select * from table;

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thursday, November 03, 2011 1:03:12 pm hubert depesz lubaczewski wrote:
> On Thu, Nov 03, 2011 at 10:55:20AM -0400, Tom Lane wrote:

> 
> So, did some tests:
> 

> as you can see counts of rows in created table are more or less
> sensible, but whatever method I used - create table as, insert into,
> using sychronized_scans (initially) or not (later) - copy of the table,
> as long as it's in database, has 40 those "-1" rows.

At least it is consistent:) 
Characteristics of those forty rows.
1) creation_tsz  clustered?
2) magic_id in a range?
3) Non -1  xobject_id in a range?
4) Any other field show a similarity?


> 
> one note - maybe it wasn't clear from my original mail - when I did
> pg_dump of the xobjects table, it didn't have -1 rows.

-- 
Adrian Klaver
adrian.klaver@xxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux