s for thousands of
servers, so 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/
: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
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 qu
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 ch
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
7.3.9 and also running tests on an 8.0.1 system.
Thanks in advance,
--- Steve
_______
Steven Rosenstein
IT Architect/Developer | IBM Virtual Server Administration
Voice/FAX: 845-689-2064 | Cell: 646-345-6978 | Tieline:
out of the 7.3 db) before
we start.
_______
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: sro
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 @ mobile.mycingular.com
Email: srosenst @ us.ibm.com
"Learn from the mistakes of others because you can't live
9276
692346 | 9276
692347 | 9276
692348 | 9276
--8< SNIP --
694167 | 9311
694168 | 9311
694169 | 9311
694170 | 9311
694171 | 9311
(2045 rows)
Time: 8703.56 ms
vsa=
4967.95 ms
What I may end up doing is using the scripting language PHP to solve the
issue by running one query just to return the summary table ID's, and then
DELETE all the rows matching each ID individually by looping through the
ID's. I was looking for something more elegant, but this will
is the best workaround?
I want to delete just the records in the detail table, and not its parent
summary record.
Thanks in advance for your help,
--- Steve
___________
Steven Rosenstein
IT Architect/Developer | IBM Virtual Se
. They're at the higher end, but from
what I understand, they provide much more bang for the buck than
Intel-based servers.
I hope this helps,
--- Steve
_______
Steven Rosenstein
Senior IT Architect/Specialist | IBM
ats collection
turned on, to try to see 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
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
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 th
15 matches
Mail list logo
