"Mr. Dan" <[EMAIL PROTECTED]> writes:
> Looking back and comparing the data, we realized that its always missing
> rows in 25 (24+1) rows sequences or we're calling it a block. So, there were
> 2 blocks of 25 missing in the 2nd attempt and 4 blocks of 25 missing in the
> third.
This is pretty
This behavior is on big tables.
6.5 GB - 12+ million records
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On 9/12/06, Allan Kamau <[EMAIL PROTECTED]> wrote:
create table tableA(s_l_p_p_v_i text not null,field1 text not null,field2 text not null,primary key(field1,field2));s_l_p_p_v_i field1 field1abc 2 1xyz 2 4klm 2 3
Your initial query: select field2||'_'||field1
Hi guys!I'm in a deadlock. I have to sync data in two servers over internet, but i haven't found any solution for that. The link is not that good, so availability is not 100% and I have to deal with these outages.
I cannot just drop a table and recover from a dump from the other server, because I'
create table tableA(
s_l_p_p_v_i text not null,
field1 text not null,
field2 text not null,
primary key(field1,field2));
s_l_p_p_v_i field1 field1
abc 2 1
xyz 2 4
klm 2 3
--- Aaron Bono <[EMAIL PROTECTED]> wrote:
> On 9/12/06, Allan Kamau <[EMAIL PROTECT
Yes - we are doing select count(*) from
the stats are worthless until you
vacuum and we aren't running vacuum. Plus those change too often to be
reliable, they just make a good guess
---(end of broadcast)---
TIP 9: In versions below 8.0, the pl
On 9/12/06, Allan Kamau <[EMAIL PROTECTED]> wrote:
Hi all,This is a plain simple sql question appologies forposting it here.Am looking for a way of combining values from severalfields(and introducting value separators).select field2+"_"+field1 from tableA;
I've triedselect field2||'_'||field1 from
Hi all,
This is a plain simple sql question appologies for
posting it here.
Am looking for a way of combining values from several
fields(and introducting value separators).
select field2+"_"+field1 from tableA;
I've tried
select field2||'_'||field1 from tableA;
I get "1" as the result(which is
No, there are different blocks of records missing every time.
If you repeat the entire experiment, are the same records missing each
time? I'm wondering about flaky hardware as much as anything.
---(end of broadcast)---
TIP 1: if posting/
Hi,
Thanks for this quick response.
##Try dumping the second table with COPY TO and diff'ing the dump files to
get more detail about what's missing.##
We tried 3 times from a local file system, instead of the NFS mount (to try
to rule out hardware)
1st attempt: the data copied over fine
2
Thank you Marco Bizzarri.My solution would be C API.Thanks for you prompt response.:)Purusothaman AOn 9/11/06, Marco Bizzarri
<[EMAIL PROTECTED]> wrote:
On 9/11/06, Purusothaman A <[EMAIL PROTECTED]> wrote:> Hi Marco Bizzarri and Martijn van Oosterhout,>>> Thanks for your valuable reply.
>> I am t
Sorry Tom, Somone had not put the reply to header in correctly..
-- Forwarded message --
From: Peter Childs <[EMAIL PROTECTED]>
Date: 12-Sep-2006 10:16
Subject: Re: [ADMIN] COPY FROM command v8.1.4
To: Tom Lane <[EMAIL PROTECTED]>
On 11/09/06, Tom Lane <[EMAIL PROTECTED]> wr
12 matches
Mail list logo
