[PERFORM] Alternative to a temporary table

every bit of efficiency helps. If this is not the proper group for this kind of question, please point me in the right direction. Thanks! --- Steve ___ Steven Rosenstein IT Architect/Developer | IBM Virtual Server

[PERFORM] Unable to explain DB error

:31 04CE Any idea why Postgres would be looking for a clog file name 0FC0 when the most recent filename is 04CE? Any help and suggestions for recovery are appreciated. --- Steve ___ Steven Rosenstein IT Architect

[PERFORM] Questions about temporary tables and performance

Postgres Version: 7.3.9 and 8.0.1 (different sites use different versions depending on when they first installed Postgres) Migration Plans: All sites on 8.n within the next 6-9 months. Scenario: A temporary table is created via a SELECT blah INTO TEMPORARY TABLE blah FROM The SELECT

[PERFORM]

In our application we have tables that we regularly load with 5-10 million records daily. We *were* using INSERT (I know... Still kicking ourselves for *that* design decision), and we now converting over to COPY. For the sake of robustness, we are planning on breaking the entire load into

[PERFORM] Bulk COPY end of copy delimiter

system. Thanks in advance, --- Steve ___ Steven Rosenstein IT Architect/Developer | IBM Virtual Server Administration Voice/FAX: 845-689-2064 | Cell: 646-345-6978 | Tieline: 930-6001 Text Messaging: 6463456978

Re: [PERFORM] Bulk COPY end of copy delimiter

Your assumption is correct. The data was generated out of a DB2 database, and uses commas as field delimiters. Thank you for the workaround, --- Steve ___ Steven Rosenstein IT Architect/Developer | IBM Virtual

[PERFORM] Are JOINs allowed with DELETE FROM

in the detail table, and not its parent summary record. Thanks in advance for your help, --- Steve ___ Steven Rosenstein IT Architect/Developer | IBM Virtual Server Administration Voice/FAX: 845-689-2064 | Cell: 646

Re: [PERFORM] Are JOINs allowed with DELETE FROM

the only solution. Thank you all for your help with this. --- Steve ___ Steven Rosenstein IT Architect/Developer | IBM Virtual Server Administration Voice/FAX: 845-689-2064 | Cell: 646-345-6978 | Tieline: 930-6001 Text

[PERFORM] Can the V7.3 EXPLAIN ANALYZE be trusted?

--8 SNIP -- 694167 | 9311 694168 | 9311 694169 | 9311 694170 | 9311 694171 | 9311 (2045 rows) Time: 8703.56 ms vsa=# ___ Steven Rosenstein

Re: [PERFORM] Are JOINs allowed with DELETE FROM

___ Steven Rosenstein IT Architect/Developer | IBM Virtual Server Administration Voice/FAX: 845-689-2064 | Cell: 646-345-6978 | Tieline: 930-6001 Text Messaging: 6463456978 @ mobile.mycingular.com Email: srosenst @ us.ibm.com Learn from the mistakes of others because you can't live long enough

Re: [PERFORM] Can the V7.3 EXPLAIN ANALYZE be trusted?

. ___ Steven Rosenstein IT Architect/Developer | IBM Virtual Server Administration Voice/FAX: 845-689-2064 | Cell: 646-345-6978 | Tieline: 930-6001 Text Messaging: 6463456978 @ mobile.mycingular.com Email: srosenst @ us.ibm.com Learn from the mistakes

Re: [PERFORM] This query is still running after 10 hours...

if I can find out what's causing this to occur. I'll post the results if I find anything significant. --- Steve ___ Steven Rosenstein Senior IT Architect/Specialist | IBM Virtual Server Administration Voice/FAX: 845

[PERFORM] Infinite CPU loop due to field ::type casting

Gentlefolk, I'm not sure if this is the proper forum for this question, and it might have been answered in a previous thread, but I'm new to PostgreSQL and the research I did in the archives did not turn up anything addressing this issue. Please direct me to the proper forum is this is not

[PERFORM] Fw: Infinite CPU loop due to field ::type casting, Take II :-)

I just realized in my haste to send this email out I provided the wrong table in my example. Below is the same email, but with vsa.dtbl_logged_event_20040922 substituted for vsa.tbl_sad_event. Sorry for the inconvenience. --- Steve Gentlefolk, I'm not sure if this is the proper forum for