Rick Gigger <[EMAIL PROTECTED]> wrote:
> >>One more question; on one server the Vacuum Analyze before the insert takes
> >>approx. 2min after that the same command takes 15min.
> >
> >
> > You might try a VACUUM FULL sometime when you can deal with 15min of downtime
> > or so. Actually it would
The link you have down there is not the one on the site. All of the
links to that file work just fine for me on the live site.
Jan Wieck wrote:
On 6/4/2004 4:47 AM, Karel Zak wrote:
On Fri, Jun 04, 2004 at 01:01:19AM -0400, Jan Wieck wrote:
Yes, Slonik's,
it't true. After nearly a year the Slony
Hi All,
I have a java web server (Tomcat) running a web application that uses PostgreSQL for
all
of the data. All of the management of the application is done through the web
application
and I would like to provide a backup and restore option for the user. Backup would
somehow get all of the d
One more question; on one server the Vacuum Analyze before the insert takes
approx. 2min after that the same command takes 15min.
You might try a VACUUM FULL sometime when you can deal with 15min of downtime
or so. Actually it would probably be longer. Perhaps the table that's taking
15min has a t
Greg Stark wrote:
Alex <[EMAIL PROTECTED]> writes:
There won't be anything to VACUUM after the insert, but perhaps you still want
to run ANALYZE. Note that a plain ANALYZE uses a statistical sample which is
much faster, whereas VACUUM ANALYZE has to look at every record anyways so
it's slower but
on 6/2/04 1:53 PM, [EMAIL PROTECTED] purportedly said:
> Keary Suska wrote:
>> I followed the directions in the /src/tools/thread directory, ran the test
>> program, which said everything was OK and recommended another setting, which
>> I added to the template/reconfigured/recompiled. Both the tes
Title: RE: [GENERAL] TimeOf(Subselects|Joins)FromLargeTables?
Or this correlated subquery:
SELECT a.name, a.seq FROM prots as a
WHERE EXISTS (
SELECT '1'FROM kwx as b
WHERE b.kw_acc=812
and b.fid = a.fid
);
-Original Message-
From: Dann Corbit [mailto:[EMAIL PROTECTED]]
Sent: Thu
it may be not that bad - thanks to Martijn van
Oosterhout's tool, we can recover all the tables apart
from three which type could not be recognised.
this was a test db. but i have learnt a lot and also
have a feel of the seriousness if the real thing
broken.
Thanks to every one and i hope that no
Agreed! The sooner SCO goes bankrupt the better.
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
[EMAIL PROTECTED]
Fax: (416) 441-9085
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Gavin M. Roy
> Sent
The vacuum of my db is failing with this error.
[seodb:/var/adm] postgres% ./vacuumdb.sh
ERROR: Invalid UNICODE character sequence found (0xed5c30)
vacuumdb: vacuum EventManager failed
I don't understand how an invalid character was allowed. How can I
eliminate the sequence/data?
thanks,
--
While the sentiment about supporting pgsql friendly vendors is valid,
personally, I'd sooner use dbase 3 than give SCO any money.
Gavin
On 03 Jun 2004 14:51:16 -0400, Robert Treat
<[EMAIL PROTECTED]> wrote:
>
> On Tue, 2004-06-01 at 06:42, Shridhar Daithankar wrote:
> > On Tuesday 01 June 2004 1
On Fri, Jun 04, 2004 at 11:39:53 +0100,
mike <[EMAIL PROTECTED]> wrote:
>
> So far I am getting an overall max or no insert.
>
> this is my query
>
> SELECT subj,area, CASE WHEN max(file_no) IS NULL THEN '1' ELSE max
> (file_no)+1 END FROM tb_files GROUP BY (subj||area),subj,area;
You should
can any one tell me about the meaning of
pg_xlog/0F1
pg_xlog/0F2
pg_xlog/0F3
pg_xlog/0F4
..
pg_xlog/0F8
is the
pg_xlog/000
missing
thanks
chneg
=
Best wishes
Z C Wang
___
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> Sigh. Sorry, that tool really needs some TLC to get it working across
> all the versions of PostgreSQL I don't have access to. It's looking for
> pg_class and is assuming it's OID 1259 and trying to open that file.
> Evidently it's failing.
I do
Thanks Martijn
if i dump the db (pg_dumpall), the delete the pgsql
dir, start a new pgsql dir, the import with template1,
this error gone and the db can be checked by your
excelent tool.
also what is
--Table arraytype.. Unknown type
thanks
--- Martijn van Oosterhout <[EMAIL PROTECTED]> wro
Sigh. Sorry, that tool really needs some TLC to get it working across
all the versions of PostgreSQL I don't have access to. It's looking for
pg_class and is assuming it's OID 1259 and trying to open that file.
Evidently it's failing.
You'd need to indicate the version of the database, maybe strac
Alex <[EMAIL PROTECTED]> writes:
> How reasonable is it to run a Vacuum Analyze before and after the
> insert/update of the data.
On a busy system you should run vacuum more often than once per day.
You should probably run a VACUUM after the update. And running ANALYZE at the
same time isn't a b
=?iso-8859-1?q?zhicheng=20wang?= <[EMAIL PROTECTED]> writes:
> in case it is useful to any one. the db server uses
> san to store the data. the update is only to the bios
> of the fibre card. if this is wrong, many other files
> should also go wrong, which is not the case.
What you should be looki
Missed one out, ... the script for sequences is:
select 'grant all on '||n.nspname||'.'||c.relname||' to MYUSERNAME;'
from pg_class c, pg_namespace n
where n.oid = c.relnamespace
and c.relkind IN ('S')
and n.nspname in ('SOMESCHEMA1', 'SOMESCHEMA2');
John Sidney-Woollett
hi,
has any one used Martijn van Oosterhout's PostgreSQL
table checker and dumper (pgfsck, at
http://svana.org/kleptog/pgsql/pgfsck.html)?
i ran this again my database and it gives this error:
Couldn't find relation pg_class(1259)
does any one know what this is about
cheng
=
Best wishes
sorry for the late reply
in case it is useful to any one. the db server uses
san to store the data. the update is only to the bios
of the fibre card. if this is wrong, many other files
should also go wrong, which is not the case.
cheng
--- Tom Lane <[EMAIL PROTECTED]> wrote: >
=?iso-8859-1?q?zh
Chris Ochs said:
> Is there a shortcut to grant all privileges on a schema and it's objects
> to
> a user without having to issue GRANT statements for each individual
> object
> in the schema? Given all the possible types of objects I doubt it but
> thought I would ask just in case there was a wa
Hi,
I have not been able to connect to news.postgresql.org over the last couple
of days. I've tried from several locations/computers. Is anyone else having
the same problem?
Kind regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9: the planne
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jan Wieck
> Sent: 04 June 2004 12:50
> To: Karel Zak
> Cc: Slony-I Mailing List; PostgreSQL-development; PostgreSQL
> advocacy; PostgreSQL General
> Subject: Re: [HACKERS] Slony-I goes BETA
>
> Gre
Hi Thx Mike, it's the best solution i think.
But i did some modifications to the code since i need to store an integer I
wrote the following:
#include "postgres.h"
#include "fmgr.h"
int32 session_data;
PG_FUNCTION_INFO_V1(setvalue);
Datum setvalue(PG_FUNCTION_ARGS) {
session_da
On 6/4/2004 4:47 AM, Karel Zak wrote:
On Fri, Jun 04, 2004 at 01:01:19AM -0400, Jan Wieck wrote:
Yes, Slonik's,
it't true. After nearly a year the Slony-I project is entering the BETA
phase for the 1.0 release. Please visit
http://gborg.postgresql.org/project/slony1/news/newsfull.php?news_id=174
Folks,
on the gborg front page is a link to the "pgreplication" project as one
of five "top" projects. This thing has had zero updates since its last
attempts agains PostgreSQL 7.2 and appears literally dead.
Can someone please remove that?
Jan
--
#===
I am trying to do the following
I have a table with three relevant fields
subj, area, and no
What I want to do is insert a sequential number by a group on the first
two fields eg:
values existing
sub | area| no
1 | 1 | 1
1 | 1 |
Nagib Abi Fadel wrote:
So considering those facts, it would be better to use the Sequence Method,
since it would only require cleaning up one table
Or is there anything else i am missing ???
It is becoming more of a toss-op. Prior to 7.4, the system indexes
would grow until a manual REINDEX w
Wait i did the following test:
SELECT count(*) from pg_class ;
count
---
894
SELECT count(*) from pg_attribute ;
count
---
7264
CREATE temp table temp_test (id integer);
CREATE TABLE
SELECT count(*) from pg_class ;
count
---
895
SELECT count(*) from pg_attribute ;
count
On Fri, Jun 04, 2004 at 01:01:19AM -0400, Jan Wieck wrote:
> Yes, Slonik's,
>
> it't true. After nearly a year the Slony-I project is entering the BETA
> phase for the 1.0 release. Please visit
>
> http://gborg.postgresql.org/project/slony1/news/newsfull.php?news_id=174
Jan, the link
http
On Fri, 4 Jun 2004 11:23:30 +0200, "Nagib Abi Fadel"
<[EMAIL PROTECTED]> wrote:
>According to those results the meta_data for a temp table are automatically
>removed when the table is destroyed
Yes, but the dead tuples remain. Try
VACUUM VERBOSE pg_class;
VACUUM VERBOSE pg_attrib
So considering those facts, it would be better to use the Sequence Method,
since it would only require cleaning up one table
Or is there anything else i am missing ???
- Original Message -
From: "Manfred Koizar" <[EMAIL PROTECTED]>
To: "Nagib Abi Fadel" <[EMAIL PROTECTED]>
Cc: "Mike
33 matches
Mail list logo
