Ok, then if I store 4K - 1byte in a varchar and after that 4K + 1 byte,
and again and again, you are saying me that my text will be jerking
around 2 tables?
So in reality no performance degradation/benefits for varchar vs text,
should be read as 'varchar as slow as text' or keep you varchar under 4
I know that when a table grows to the point where it is larger than 1GB,
the backend opens up a 2nd data file. (And a 3rd when it grows beyond
2GB, etc.)
By testing it, I have learned that what it does (at least on a Linux box)
is to create a file with a numbered extension appended to the name,
On 3 Jul 2003 at 13:18, Tom Lane wrote:
> Comments?
Now that my NZ server is up and running:
template1=# select now();
now
---
2003-07-05 12:47:15.444535+12
That doesn't look backwards to me. Perhaps I don't understand the
problem. After rereading y
On Fri, Jul 04, 2003 at 02:22:39PM -0700, Maksim Likharev wrote:
> Ok, what I see here tells me that text is slower then fixed len varchar,
> due to stored in separate table ( but how else you can store long fields
> ).
> so postgres has to read another page(s) in order to get long value.
That's r
That's "long values" that are stored elsewhere. I believe the length has to be
a good portion of a page size, normally 4KB, before it's considered for placing
in the toast table. I'm not sure if the details are in the documentation but
I'm sure they'll appear in a search of the archive. Of course,
Ok, what I see here tells me that text is slower then fixed len varchar,
due to stored in separate table ( but how else you can store long fields
).
so postgres has to read another page(s) in order to get long value.
Story about boundary checks for varchar just does not count,
just nothing with com
On Fri, Jul 04, 2003 at 01:14:52PM -0700, Maksim Likharev wrote:
> How postgres internally stores text fields, in a separate table?
I believe it gets stored in a separate table just in case it's too
long (read the docs on TOAST if you want more about this). But
normally, no. Here's what the docs
How postgres internally stores text fields, in a separate table?
-Original Message-
From: Andrew Sullivan [mailto:[EMAIL PROTECTED]
Sent: Friday, July 04, 2003 12:55 PM
To: PostgreSQL List
Subject: Re: [GENERAL] Datatypes and performance
On Fri, Jul 04, 2003 at 09:10:41AM -0700, Jay O'Co
On Fri, Jul 04, 2003 at 09:10:41AM -0700, Jay O'Connor wrote:
> Based on the docs, they say that there's not performance difference between
> using varchar(n) and text.
>
> So will leaving my fields as unlimited varchar be a performance issue? Or
> should I try to narrow them down?
In fact, ther
Andrew Sullivan <[EMAIL PROTECTED]> writes:
>> On Fri, Jul 04, 2003 at 02:52:41PM +0800, Weiping He wrote:
>>> pmdie 2
>>
>> Just a hunch, but could this have anything to do with power
>> management? That's controlled by a program called pm.
Nah, it's coming from the postmaster's signal-catching
On Fri, Jul 04, 2003 at 03:45:04PM -0400, Andrew Sullivan wrote:
> On Fri, Jul 04, 2003 at 02:52:41PM +0800, Weiping He wrote:
> >
> >pmdie 2
>
> Just a hunch, but could this have anything to do with power
> management? That's controlled by a program called pm.
Hmm. Not a program, after al
On Fri, Jul 04, 2003 at 02:52:41PM +0800, Weiping He wrote:
>
>pmdie 2
Just a hunch, but could this have anything to do with power
management? That's controlled by a program called pm.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS
On Thu, Jul 03, 2003 at 20:37:08 +0200,
Darko Prenosil <[EMAIL PROTECTED]> wrote:
>
> But unfortunately, I think that triggers and rules are not working on system
> objects.
You can't put triggers on system tables. I am not sure about rules, but I
would expect the same limitation.
You probably
- Original Message -
From: "Mattias Kregert" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Darko Prenosil" <[EMAIL PROTECTED]>
Sent: Friday, July 04, 2003 7:11 PM
Subject: Re: [GENERAL] Q: Executing functions at connect/disconnect?
Is it possible to use pg_backend_pid() or pg_stat_act
- Original Message -
From: "Mattias Kregert" <[EMAIL PROTECTED]>
To: "Darko Prenosil" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 04, 2003 6:08 PM
Subject: Re: [GENERAL] Q: Executing functions at connect/disconnect?
Just as i thought...
I have only one solution then; t
Mike Richardson and John Dean are pleased to announce the 2.0 release of
Rekall, a personal, programmable DBMS system for Linux and Windows. If you
want to distribute your Rekall application commercially then there is a
run-time version of Rekall V2.0.0 available too. There are also versions
avail
Is it possible to use pg_backend_pid() or pg_stat_activity in some way?
I tried to put a rule on pg_stat_activity:
create rule cleanup as on delete to pg_stat_activity do ...
...but it does not work... i disconnected and the backend was removed from
pg_stat_activity, but the rule did not exec
I would add a nohup.
In addition, are you using the Solaris performance/process monitoring
tools? I forget which one, maybe pfiles, would occasionally send wierd
signals to processes. Check your cron listings to see if you're running
anything like that.
Jon
---(end of
I have created a patch to postgresql 7.3.3 to make pg_dump more CVS
friendly. Basically, pg_dump numbers all of it's TOC entries. Therefore,
if you modify or recreate a view that used to be at the beginning, then
ALL of your tables/indexes/etc get renumbered, which causes a lot of junk
in your CV
Just as i thought...
I have only one solution then; to have a cleanup function which is executed every now
and then...
Cleanup function:
1. Look in the Session table to find out which sessions are registered.
2. Determine if some of these sessions are "dead".
3. Update all those items/objects/row
Tom Lane wrote:
Weiping He <[EMAIL PROTECTED]> writes:
Later I use:
pg_ctl start >pgrun.log 2>&1
to start the program, and it runs ok. but, then the pmdie 2...
Hm. My first thought was that you needed a
We should check the theory though. After you start the postmaster
using the above co
On Fri, Jul 04, 2003 at 09:10:41AM -0700, Jay O'Connor wrote:
> I created a database schema and based on the test data I had to work with,
> I couldn't really determine the max size of a lot of string fields so I
> just left a lot of fields as varchar
>
> A comment from a coworker was that this w
On Friday 04 July 2003 21:40, Jay O'Connor wrote:
> 2.varchar and int
> I was using a varchar as one field that's part of an index. Looking at the
> data, I realized I could just use an int instead. My assumption would be
> that an int would be faster to serach for thena varchar, so I converted
Couple of questions on datat types and performance
1. varchar vs varchar(2)
I created a database schema and based on the test data I had to work with,
I couldn't really determine the max size of a lot of string fields so I
just left a lot of fields as varchar
A comment from a coworker was that t
Weiping He <[EMAIL PROTECTED]> writes:
> Later I use:
> pg_ctl start >pgrun.log 2>&1
> to start the program, and it runs ok. but, then the pmdie 2...
Hm. My first thought was that you needed a
Tom Lane wrote:
Weiping He <[EMAIL PROTECTED]> writes:
I've met a wierd problem on a Solaris 8/sparc box with postgresql 7.3.3:
the server would automatically shutdown after a period of time of not
operating. The log show something like this:
pmdie 2
Assuming signal 2 is SIGINT
Weiping He <[EMAIL PROTECTED]> writes:
> I've met a wierd problem on a Solaris 8/sparc box with postgresql 7.3.3:
> the server would automatically shutdown after a period of time of not
> operating. The log show something like this:
> pmdie 2
Assuming signal 2 is SIGINT on Solaris
Martin Marques wrote:
On Vie 04 Jul 2003 03:52, Weiping He wrote:
Hi, all,
I've met a wierd problem on a Solaris 8/sparc box with postgresql
7.3.3:
the server would automatically shutdown after a period of time of
not operating. The log show something like this:
pmdie 2
anybody us
On Vie 04 Jul 2003 03:52, Weiping He wrote:
> Hi, all,
>
> I've met a wierd problem on a Solaris 8/sparc box with postgresql
> 7.3.3:
>
> the server would automatically shutdown after a period of time of
> not operating. The log show something like this:
>
> pmdie 2
>
> anybody usin
Hello,
> We share the same ideas. Please refer to (CVS is down at the
> moment) :
> http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/*checkout*/pgadmin3
>/docs/en_US/translation_guidelines.html
Just a little french mistake at the end of the document :
>Do not choose distant words, like "déclancheur"
On Thursday 03 July 2003 12:32, A. van Roggen wrote:
> If you ever have read the instruction books for e.g. early VCR
> recorders, translated from the original Japanese to English, you will know
> exactly what I mean. Proper translation is not an easy job, and
> volunteers from another branch of t
Is there a way to pass NEW or OLD from inside of trigger into some function ?
I have situation where "versions" of row calculations are offten changed, so I
would like to make "case" with function calls depending on version number.
If I make case with actual code inside trigger function, i
The following message have been reported in the logs during data insertion:
DBD::Pg::st execute failed: ERROR: Invalid UNICODE character sequence
found (0xc567)
DBD::Pg::st execute failed: ERROR: Unicode >= 0x1
DBD::Pg::st execute failed: ERROR: pg_atoi: error in
"
33 matches
Mail list logo
