>
> "Coby Beck" <[EMAIL PROTECTED]> writes:
> > I get the following error trying to update a view:
> > "ERROR: query rewritten 10 times, may contain cycles"
>
> Update to something newer. The default limit is 100 in 7.3, and the
> whole thing is gone in favor of *real* loop detection in 7.4 ...
T
hal <[EMAIL PROTECTED]> writes:
> What is the best/simplest way to split:
> ...
> across more than one disk drive?
LVM or RAID solutions should do the job.
regards, tom lane
---(end of broadcast)---
TIP 2: you can get off al
> I don't see orders-of-magnitude bloat here though. You've got 16 bytes
> of useful data per row (which I suppose was 12 bytes in the flat file?).
> There will be 28 bytes of overhead per table row. In addition the index
> will require 12 data bytes + 12 overhead bytes per entry; allowing for
>
"Coby Beck" <[EMAIL PROTECTED]> writes:
> I get the following error trying to update a view:
> "ERROR: query rewritten 10 times, may contain cycles"
Update to something newer. The default limit is 100 in 7.3, and the
whole thing is gone in favor of *real* loop detection in 7.4 ...
"Chris White (cjwhite)" <[EMAIL PROTECTED]> writes:
> I have just installed 7.4.2 and initialized a database using the default
> values. When I start the database It fails with the following message:
> FATAL: invalid value for parameter "lc_messages": "en_US"
What platform is this exactly? And e
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Well,you obviously signed up to the list, otherwise you wouldn't be on it.
Just send a mail to
[EMAIL PROTECTED]
and write the following into the body of the mail:
unregister [EMAIL PROTECTED]
and DON'T do that as html mail - probably won't work.
PLEASE, PLEASE PLEASE unsubscribe my name off this
list!!! I never asked to be signed up! All I know is that the members of this
group send 10 - 30 emails to me and I do not like the HARRASSMENT! PLEASE take
[EMAIL PROTECTED] off this
list-
Scott
Sorry to harass the list, and Scott, again ... could someone please remove this guy
before he loses all faith in computers ?
;-)
Greg W.
(ps sorry Scott - I don't have a clue as to how to remove you myself)
-Original Message-
From: scott [mailto:[EMAIL PROTECTED]
Sent: Thursday, April
Found out that Postgres was compiled with the wrong int64 option.
Changed it to HAVE_LONG_LONG_INT64 and was able to insert data into the
table
-Original Message-
From: Gregory S. Williamson [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 4:35 PM
To: [EMAIL PROTECTED]; [EMAIL PRO
I just tried the sql below on a 7.4 instance and it works fine.
# insert into vm_mailbox
values('PERSONAL000',0,null,1,60,true,0,30,true,
10,0,1081462504500);
INSERT 13985274 1
Are you sure this is the offending data ?
Greg Williamson
DBA
GlobeXplorer LLC
-Original M
I have just upgraded to 7.4.2 from 7.2.1 and I am having problems
inserting data into a database table that worked just fine under 7.2.1.
I have a table defined as follows:
create table vm_mailbox
(
MailboxId varchar(64) not null,
MailboxType integer not null default 0,
Description varchar(64) ,
Tom Lane wrote:
Gaetano Mendola <[EMAIL PROTECTED]> writes:
using Postgres 7.4.2 I'm seeing in my log
file thousand of line with "CONTEXT: "
Any particular context?
No just mine own:
LOG: statement: select sp_id_admin();
LOG: statement: SELECT id_admin FROM administrators WHERE user_name =
What is the best/simplest way to split:
a database
multiple databases
a table
multiple tables
across more than one disk drive?
I know that this has come up before but I can't find
any info. A pointer to a HOWTO or other info would
be wonderful.
hal
Title: Message
Okay
have found info in documentation and have change locale support to
C.
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Chris White (cjwhite)Sent: Thursday, April 08,
2004 10:53 AMTo: [EMAIL PROTECTED]Subject:
[ADMIN]
scott.marlowe wrote:
I replied, and finally got him unsubscribed from the list.
He was just tired of receiving our admin list all the time and
couldn't figure out how to turn it off, so I walked him through the
web interface to get off the list.
So he chose such an appropriate solution since he wa
Hi,
I get the following error trying to update a view:
"ERROR: query rewritten 10 times, may contain cycles"
and it doesn't. There is a function in there legitimately called 10 times
with the same parameters. 10 seems a little low to panic about, is this
configurable? The rule code is generat
Title: Message
I have just
installed 7.4.2 and initialized a database using the default values. When I
start the database It fails with the following message:
FATAL: invalid
value for parameter "lc_messages": "en_US"
Looking at the
postgresql.conf file I see the following lines:
# The
"Tony and Bryn Reina" <[EMAIL PROTECTED]> writes:
> CREATE TABLE SegmentValues (
> dbIndex integer REFERENCES EntityFile (dbIndex),
> dwunitid smallint,
> dwsampleindex smallint,
> dtimestamp float4,
> dvalue float4,
> PRIMARY KEY (dbIndex, dtimest
On Thursday 08 April 2004 5:51 am, Tony and Bryn Reina wrote:
> Yep. That's after a 'vacuum verbose analyze'.
No, he asked if you had run a "vacuum full". A "standard" vacuum just
marks space available for reuse - it does not shrink file sizes. A
"vacuum full" will shrink the files on disk.
Are
I replied, and finally got him unsubscribed from the list.
He was just tired of receiving our admin list all the time and couldn't
figure out how to turn it off, so I walked him through the web interface
to get off the list.
On Thu, 8 Apr 2004, Terry Hampton wrote:
>
> Anyone know this
"Tony and Bryn Reina" <[EMAIL PROTECTED]> writes:
> There's only about 11 tables in the DB. I included them at the bottom
> in case you're interested.
What are the actual sizes of the tables? Probably the most useful way
you could present that info is "vacuum verbose" output for each table.
On Thu, 8 Apr 2004, Terry Hampton wrote:
> Anyone know this list member,
> who was kind enought to reply?
No, but he's sent me private messages of the sort
in the past (and in fact also sent on in response
to my reply to this message).
> Original Message
> Subject:
> Well, an important question is where is that space going? It'd be
> interesting to give a breakup by the directories and then which files (and
> using the contrib/oid2name to get which table/indexes/etc they are).
>
> At least 16MB of that is probably going into the transaction log (IIRC
> that's
Title: Connecting to PostgreSQL via PgAdmin III
I'm having trouble connecting to a Fedora Box that's running PostgreSQL. Below are my configuration files... any idea what I've setup incorrectly?
This is the error that I get when connecting with pgAdmin III
"Error connecting to the
Anyone know this list member,
who was kind enought to reply?
Original Message
Subject: Re: [ADMIN] Location of a new column
Date: Thu, 8 Apr 2004 06:58:56 -0700
From: "scott" <[EMAIL PROTECTED]>
To: "Terry Hampton" <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> using Postgres 7.4.2 I'm seeing in my log
> file thousand of line with "CONTEXT: "
Any particular context?
> I need to habe the log level debug2,
You should hardly gripe about bulkiness of the log in that case...
> and I'm seeing that the CONTEXT
[EMAIL PROTECTED] (Tony Reina) writes:
> However, a 65X bloat in space seems excessive.
Without concrete details about your schema, it's hard to answer that.
I suspect you made some inefficient choices, but have no data.
For starters you should do a database-wide VACUUM to ensure
pg_class.relpage
Just a brief summary of my problem and it's resolution:
The postgres log file was gobbling up all my disk space and I wasn't paying
attention. Postgres shut down and wouldn't restart. I truncated the log
file and now had plenty of space but Postgres still wouldn't start.
I noticed it wasn't post
On Thu, 8 Apr 2004, Terry Hampton wrote:
> I thought this was answered before, but I
> could not find anything in my saved email.
>
> I need to ALTER a table to add a new column.
> I want the new column to be between two existing
> columns, however. Didn't I see
On Thu, 8 Apr 2004, Tony Reina wrote:
> I'm developing a database for scientific recordings. These recordings
> are traditionally saved as binary flat files for simplicity and
> compact storage. Although I think ultimately having a database is
> better than 1,000s of flat files in terms of data ac
All,
I thought this was answered before, but I
could not find anything in my saved email.
I need to ALTER a table to add a new column.
I want the new column to be between two existing
columns, however. Didn't I see mention of
an "AFTER" paramet
On Thu, 8 Apr 2004, Tony Reina wrote:
> Has anyone run across similar storage concerns? I'd be interested in
> knowing if I just have really poorly designed tables, or if something
> else is going on here. I figure a bloat of 3-4X would be permissible
> (and possibly expected). But this bloat just
Why not just get a bigger disk?
Warmest regards,
Ericson Smith
Tracking Specialist/DBA
+---+-+
| http://www.did-it.com | "When you have to shoot, shoot, |
| [EMAIL PROTECTED] | don't talk! - Tuco |
| 516-255-0500 |
Tom,
I'm not sure how to check about the postgres user disk space limit issue. I
tried storing a rather large file on the postgres partition as the postgres
user and had no problem. I'm more suspicious of the file stored in:
[EMAIL PROTECTED] data]# ls -l /var/lib/pgsql/data/pg_xlog/
total 1640
I'm using 'text' instead of char. That seemed to cut the bloat down by about
30%. There's only about 11 tables in the DB. I included them at the bottom
in case you're interested.
Perhaps there's just something fundamentally boneheaded about my design
(re-reading "Database Design for Mere Mortals"
Yep. That's after a 'vacuum verbose analyze'.
-Tony
- Original Message -
From: "Uwe C. Schroeder" <[EMAIL PROTECTED]>
To: "Tony Reina" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, April 08, 2004 11:57 AM
Subject: Re: [ADMIN] Database storage bloat
-BEGIN PGP SIGNED MESS
Saying "we've set field sizes to their theoretical skinniness" makes me
think that
you may have the wrong data types. For example, you may have used CHAR
and not VARCHAR.
douglas
Tony Reina wrote:
I'm developing a database for scientific recordings. These recordings
are traditionally saved
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
using Postgres 7.4.2 I'm seeing in my log
file thousand of line with "CONTEXT: "
I need to habe the log level debug2, and I'm
seeing that the CONTEXT disappear only with:
log_min_messages = fatal
I think the fatal level is too much in order to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Did you run vacuum full after your import ?
On Thursday 08 April 2004 02:15 am, Tony Reina wrote:
> I'm developing a database for scientific recordings. These recordings
> are traditionally saved as binary flat files for simplicity and
> compact stor
I'm developing a database for scientific recordings. These recordings
are traditionally saved as binary flat files for simplicity and
compact storage. Although I think ultimately having a database is
better than 1,000s of flat files in terms of data access, I've found
that the database (or at least
40 matches
Mail list logo