[GENERAL] Import large data set into a table and resolve duplicates?

that - the dictionary table already consists of ~200K records - the patch could be ~1-50K of records long Thanks! -- Eugene N Dzhurinsky pgpbp5vcVZ4XQ.pgp Description: PGP signature

Re: [GENERAL] Import large data set into a table and resolve duplicates?

eter. Then truncate existing dictionary table and COPY the data from the merged file into it. Is it what you've meant? Thank you! -- Eugene Dzhurinsky pgpQFsOplL4EJ.pgp Description: PGP signature

Re: [GENERAL] Import large data set into a table and resolve duplicates?

ks really promising, thank you John! I need only one index on the "patch_data" table, and I will re-use the existing index on the "dictionary". Thanks again! -- Eugene Dzhurinsky pgpY2gxa8nKur.pgp Description: PGP signature

Re: [GENERAL] Import large data set into a table and resolve duplicates?

uot; table on "series" column. But perhaps it's better to try this and if a performance will go really bad - then do some optimizations, like partitioning etc. Thank you! -- Eugene Dzhurinsky pgp4hwQD7LkHm.pgp Description: PGP signature

[GENERAL] Import large data set into a table and resolve duplicates?

d that - the dictionary table already consists of ~200K records - the patch could be ~1-50K of records long - records could not be removed from the dictionary, only added if not exist Thanks! -- Eugene Dzhurinsky pgpsmOWtdvXCS.pgp Description: PGP signature

[GENERAL] modification time & transaction synchronisation problem

me data could be lost from export files sequence. And that is not good at all. I will appreciate any suggestions on how to solve this problem. I.e. how can I (within the export transaction) select all the data that was updated since the last export? Thanks. Eugene.

[GENERAL] migrating from MSSQL

t are some of the things to watch out for? Secondly, which commercial support vendor would you recommend? I found EnterpriseDB and CommandPrompt, but I don't know anything about them. Any other candidates? thanks, Eugene -- Sent via pgsql-general mailing list (pgsql-general@post

[GENERAL] migrating from MSSQL

t are some of the things to watch out for? Secondly, which commercial support vendor would you recommend? I found EnterpriseDB and CommandPrompt, but I don't know anything about them. Any other candidates? thanks, Eugene

Re: [GENERAL] How to get comments for view columns?

Tom Lane wrote: > What do you consider "selected"? Given a view defined as > > select a, b, c+d as sum from tab where e > 42; > > what output are you wishing for? > > AFAIR the dependency mechanism will treat a,b,c,d,e alike. To do more > you'd need to grovel through the pg_rewrite express

[GENERAL] How to get comments for view columns?

Hi, is there any way to get comment meta-information for columns in a view? I mean, suppose I have several tables and some of their columns have comments, then I define a view on these tables, and what I want is to somehow retrieve comments (if any) for those columns which are selected in a view. I

Re: [GENERAL] COPY FROM file with zero-delimited fields

On Apr 11, 7:42 pm, [EMAIL PROTECTED] ("Merlin Moncure") wrote: > On 11 Apr 2007 00:25:50 -0700, [EMAIL PROTECTED] > > <[EMAIL PROTECTED]> wrote: > > Hi all, > > I wonder if there's a way to use COPY FROM command when dealing with a > > data file containing records whose fields are delimited with z

[GENERAL] COPY FROM file with zero-delimited fields

Hi all, I wonder if there's a way to use COPY FROM command when dealing with a data file containing records whose fields are delimited with zero- byte? Or I'd better change the delimiter? :) ---(end of broadcast)--- TIP 4: Have you searched our list

[GENERAL] How to read cleartext user password from pgsql database

. -- Thanks, Eugene Prokopiev ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] POSTGRES DB 3 800 000 rows table, speed up?

S | TEXAS| TYLER | 32.3511| -95.2922| 75701 | HOWE-BAKER ENGINEERS INCORPORATED | - (1 row) detectlo_db=> On Wed, 28 Dec 2005 23:33:41 +0200, James Robinson <[EMAIL PROTECTED]> wrote: On Dec 28, 2005, at 4:24 PM, Eugene wrote: THIS is what I get [snip ] So

[GENERAL] POSTGRES DB 3 800 000 rows table, speed up?

ARCHAR(5), ipISP VARCHAR(255) NOT NULL, ipDOMAIN VARCHAR(128) NOT NULL ); I've indexed first two columns they are IPfrom, IPto also table is btree version of postgre is 7.4.8, on hosting I ask db like this SELECT * FROM ipdb2 WHERE '3229285376' BETWEEN ipfrom AND ipto;

[GENERAL] copy csv eclosed by analog quotes problem superuser ?

d by command, i can do this way mysql> LOAD DATA INFILE "/IP-COUNTRY-REGION-CITY-LAT-LONG-ZIPCODE-ISP-DOMAIN.CSV" INTO TABLE IPCITYLATLONGISPDOMAIN FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'; ENCLOSED BY '"' hel

[GENERAL] function in index expression and unnecessary function calls in select

ts? Is it bug? Can it be configured? -- Thanks, Eugene Prokopiev ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] total db lockup

actually, I'm using postgresql 7.3.2. I noticed there were some hash index fixes in 7.4, so that might be it. Would there be any other reason for this deadlock? This database has been in production for almost 2 years and this is the first time we've seen the problem. thank

Re: [GENERAL] total db lockup

: http://rafb.net/paste/results/W35ccD49.html thanks, Eugene > > From: Alvaro Herrera <[EMAIL PROTECTED]> > Date: 2005/08/18 Thu PM 08:52:17 EST > To: Eugene <[EMAIL PROTECTED]> > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] total db lockup > > On T

Re: [GENERAL] total db lockup

Guys, I really need help on this. Can whoever is in charge of the mailing list change it so that it doesn't delete my messages? thanks, Eugene > > From: Eugene <[EMAIL PROTECTED]> > Date: 2005/08/18 Thu PM 04:45:58 EST > To: Tom Lane <[EMAIL PROTECTED]> > CC:

Re: [GENERAL] total db lockup

It seems that I can't. For whatever reason, my messages are being blocked. Eugene > > From: Tom Lane <[EMAIL PROTECTED]> > Date: 2005/08/18 Thu PM 02:11:54 EST > To: [EMAIL PROTECTED] > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] total db lockup >

[GENERAL] boolean function return values

770403 (1 row) user1=# select count(*) from t_content where validlivesitecontent(publisher, contenttype, status) = true; count - 1258365 (1 row) Thanks! --Eugene Barlow TripAdvisor - www.tripadvisor.com ---(end of broadcast)--- TIP 3: i

Re: [GENERAL] Re: Using , instead of . for thousands..

. Perhaps a locale setting is in order? -- Eugene Lee [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[GENERAL] TRUNCATE and INDEXes

If there's one or more indexes on a table that gets TRUNCATEd, are those indexes automatically updated as expected from INSERTs and DELETEs? -- Eugene Lee [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list arc

[GENERAL] 7.0.2 install doesn't read .conf files

7.0.0.1 255.255.255.255 trust However, instead of being denied outright, I can connect to the default port from the outside world. In the logs, it shows up as an entry with a datetime stamp and a message "Invalid packet length". Is this normal PostgreSQL behavior? Any suggestions are appreciated. -- Eugene Lee [EMAIL PROTECTED]

Re: [GENERAL] Releases: 7.0.1, 7.0.2

Tue, Jun 06, 2000 at 03:24:56PM -0300, The Hermit Hacker ÐÉÛÅÔ: > On Tue, 6 Jun 2000, Eugene Karpachov wrote: > > > Excuse me, but why postgresql team doesn't release patches? I mean something > > like postgresql-7.0-7.0.1.diff.gz etc. It is big waste of traffic to down