On Wed, Jul 16, 2003 at 12:04:25PM -0500, Luis Maga?a wrote:
> Thanks,
>
> yes, it's running solaris 8 on a SPARC with SCSI disk.
Hmm. 64 bit? There've been plenty of bugs in the 64 bit libraries,
AFAICT. We've even discovered some of 'em ourselves, and I got so
leery that we still use a 32-b
I'm testing a database against the 7.4 CVS, so I did a pg_dumpall
and a restore on another system.
The database has around 130 user tables which take up a bit under 15GB of
disk space.
The dump file was about 7GB. (That seems about right based on past
experience, nobody ever said relational
"Brian Maguire" <[EMAIL PROTECTED]> writes:
> I have a couple questions about Postgres and Views.
>
> I am curious about what Postgres actually does in regards to views and
> the internal steps that it takes.
>
> Are these the steps that it takes for each query that includes a view?
> 1. Dynam
It very much looks like a problem I had before
do you have back trace, I will say for sure.
-Original Message-
From: Luis Magaña [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 10:12 AM
To: Andrew Sullivan
Cc: Postgresql General Mail List
Subject: Re: [GENERAL] ODBC query problem
I've compiled postgresql in 32bit mode, although I'm using the
--enable-integer-datetimes flag when configuring.
I've already moved database to a diferent partition nad got the same
results, I wonder, if it is a hardware problem, why can I access both
tables individually with no problem at all ?.
On Wed, Jul 16, 2003 at 12:36:34PM -0500, Luis Maga?a wrote:
> I've already moved database to a diferent partition nad got the same
> results, I wonder, if it is a hardware problem, why can I access both
> tables individually with no problem at all ?.
Doesn't sound like hardware, then. I think yo
Ouch, this means that for every insert we would have to trigger a
procedure which will:
COUNT
IF > Limit
DELETE OLDEST
This would be pretty much damn ressource intensive on a table with million
of records, would not it ?
You can keep the count in a table on the side, and have it updated by
th
Forgotten to ask, what is locale for DB cluster?
-Original Message-
From: Luis Magaña [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 10:37 AM
To: Andrew Sullivan
Cc: Postgresql General Mail List
Subject: Re: [GENERAL] ODBC query problem
I've compiled postgresql in 32bit mode, a
[EMAIL PROTECTED] wrote:
The dump file was about 7GB. (That seems about right based on past
I started the restore at 6PM last night, 18 hours later I'm hoping it is
getting close to being done, as it has been building indexes for the past
hour or so.
The test system is quite a bit slower th
OUCH!!! Do a COUNT(*) on a 10M row table Forget it.
Here is a simple solution.
Add a SERIAL field to the table.
Set the maximum value for that sequence to the number of records you
want to keep.
Use a before insert trigger to replace the insert with an update if the
key already exist.
No need
Locale is es_MX
and it seems that the hardware issue wil be the reason. I've moved it
to another partition and now is working fine. I'll do more testing.
Thanks for the help.
Regards.
On Wed, 2003-07-16 at 12:52, Maksim Likharev wrote:
> Forgotten to ask, what is locale for DB cluster?
>
> --
I've moved the database to a third location in the same disk using
pg_dumpall, the new location works with no errors, the initdb was made
without localization.
The production db was inited with es_MX locale, may that has something
to do with the problem ?.
On Wed, 2003-07-16 at 12:40, Andrew Sull
Yes it is most likely locale,
if you have core,
try to use on Solaris
pstack you_core_file, should be "pretty distinct" back trace
-Original Message-
From: Luis Magaña [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 11:06 AM
To: Andrew Sullivan
Cc: Postgresql General Mail List
Su
Good idea!
Jean-Luc Lachance wrote:
OUCH!!! Do a COUNT(*) on a 10M row table Forget it.
Here is a simple solution.
Add a SERIAL field to the table.
Set the maximum value for that sequence to the number of records you
want to keep.
Use a before insert trigger to replace the insert with an upd
All,
There's a database format called "rrd" or round robin database. this was
specifically designed for wrap-around data storage. since you are trying to
store 10mil+ syslog messages this might not be the right tool. I'm just
mentioning it because it perhaps the way the rrd keeps track of wrap-aro
--- don't think this made it through to the list ---
Hello,
I am having difficulty setting an on update rule which seems to be
caught in a recursive loop. What is the best way to modify values sent
to an update query?
If it is helpful, here is the specific situation: The context is a table
with
On Wed, Jul 16, 2003 at 01:33:35PM -0500, Leon Oosterwijk wrote:
> store 10mil+ syslog messages this might not be the right tool. I'm just
> mentioning it because it perhaps the way the rrd keeps track of wrap-around
> might be a good way to implement this in postgres.
Hmm. Using the cycling feat
- Original Message -
From: "Brian Maguire" <[EMAIL PROTECTED]>
To: "Postgresql General Mail List" <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 6:44 PM
Subject: [GENERAL] Couple Postgres View Questions
>I have a couple questions about Postgres and Views.
>I am curious about what Po
--- Ron <[EMAIL PROTECTED]> wrote:
> I am creating a new database on a brand new server
> (P4, 1GB RAM,
> postgres 7.3.3, debian 3.0) and trying to populate
> one of the tables
> with the COPY command. I split a large file with 20
> million records into
> 20 files, but when I run COPY I usually
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> It would be great if this could be achieved by RDBMS engine itself, does
> Postgres supports this kind of tables ? And if not, what would be the most
> elegant soluion to achieve our goal in your oppinion ?
First question: no. :)
Second question:
Here it is...
things to note:
This table contains 1 record allways.
The record is updated once per second.
Every 167 seconds a vacuum analyze is run on the table
After some time it hangs in the analyze and blocks all
access to that table including selects.
> > store 10mil+ syslog messages this might not be the right tool. I'm
> > just mentioning it because it perhaps the way the rrd keeps track
> > of wrap-around might be a good way to implement this in postgres.
>
> Hmm. Using the cycling feature of a sequence, couldn't you create a
> trigger whic
Folks:
I would like to thank for those who answer my questions. My client have
decide to switch from MySQL to PostgreSQL. I have successfully installed
PostgreSQL with Cygwin on my XP laptop. It's a good start. I, however, have
some other questions.
1. I am viewing the database from both PostgreS
> > > store 10mil+ syslog messages this might not be the right tool. I'm
> > > just mentioning it because it perhaps the way the rrd keeps track
> > > of wrap-around might be a good way to implement this in postgres.
> >
> > Hmm. Using the cycling feature of a sequence, couldn't you create a
> >
Sean Chittenden wrote:
store 10mil+ syslog messages this might not be the right tool. I'm
just mentioning it because it perhaps the way the rrd keeps track
of wrap-around might be a good way to implement this in postgres.
Hmm. Using the cycling feature of a sequence, couldn't you create a
On Tue, Jul 15, 2003 at 07:53:37PM +0530, Shridhar Daithankar wrote:
> Each tuple in postgresql has around 28 bytes of overhead. Index tuple has 12
Is this accurate?
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=page.html
indicates a per-tuple overhead of 23 bytes. Or have thin
On Wed, Jul 16, 2003 at 03:40:47PM -0400, Dmitry Tkach wrote:
> I believe, you can save one query by replacing 'if exists then update else
> insert' part with just 'delete unconditionally then insert'
I was going to mention this. Because updates in PGSQL are actually
DELETE/INSERT in a single st
For some of your Cygwin specific questions you may want to look at the ports
mailing list. They will be more knowledgeable there.
> I would like to thank for those who answer my questions.
> My client have decide to switch from MySQL to PostgreSQL.
> I have successfully installed PostgreSQL with C
> >I use this very approach.
> >
> >CREATE SEQUENCE syslog_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 25 CYCLE;
> >CREATE TABLE syslog (
> > id INT NOT NULL,
> > msg TEXT NOT NULL
> >);
[snip slower function]
> I believe, you can save one query by replacing 'if exists then
> update else insert' par
You could skip the extra select in any case, if you used a boolean column named
'valid_data', and always updated it with a rue, but prepopulated it with a 'false'.
Your selects OUT of the table would use the WHERE clause of 'valid_data' = TRUE.
updating and selecting on a bool would not take much
I'm going to skip the questions that I don't know the answer.
- Original Message -
From: "Terence Chang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 9:05 PM
Subject: Install new language - Prev: Re: [GENERAL] Are you frustrated with
PostgreSQL
> Folks:
>
>
"Litel Wang" <[EMAIL PROTECTED]> writes:
> I create a database in the server of my company and get a backup of this database .
> but I can't find the other schemas (such as pg_catlog,pg_toast) in my restored
> database except public schemas when I restore it at home .what's the problem ?
What do
On Wed, Jul 16, 2003 at 08:59:30PM -0400, Vernon Smith wrote:
> I don't know what is your application environment. The following is
> quoted from the page 191 of "Java Enterprise Best Practices":
>
> [...]
>
> The reference web page,
> www.postgresql.org/idocs/index.php?cjarset.html doesn't exis
I decided to look at jumpline, minimum of ~30.00 to get postgres. Does
not say if you get pl/pgsql with that or not, or daily backups, and lots
of other goodies. The price is fairly equivilent, otherwise, to pghoster.
---(end of broadcast)---
TIP 3
It would sure be nice to be able to serve any language based on UTF-8 in
binary fields with no location rquired, and any sorting done either in
binary or through an additional SQL extension such as:
SELECT some_field
FROM some_table
WHERE xlate_utf8binary_to_collations( field_name_or_select_stat
On 16 Jul 2003 at 17:11, Lynna Landstreet wrote:
> I saw a company called pgHoster (www.pghoster.com) listed on the
> techdocs.postgresql.com site and their prices for shared hosting seem
> to be in line with what we could afford (i.e. dirt cheap). But I'm
> wondering if anyone has any experience
Hello,
my case is quite difficult, I think, so all the help
you can give me is more than welcome!
The short story: I had two disks, the primary running
the database server (pg 7.1.2), the second having the
daily pg_dump's. The first disk started to have I/O
problems, the sencond disk was erased by
Hi,
No guarentees here, but this may help. It can read the postgres backend
files directly and is a bit more robust against errors. It may be able to
recover your data for you. However, it requires that the pg_class and
pg_attribute tables are still intact. It has rescued one persons 7.3 so it
doe
i tried running postgres and did a reindex..
and i got this..
...
NOTICE: relation 16596 was reindexed
NOTICE: relation 16598 was reindexed
NOTICE: relation 16384 was reindexed
NOTICE: relation 16386 was reindexed
NOTICE: relation 1262 was reindexed
ERROR: Cannot create uniq
Hi Lanna,
we are running postgresql with UNICODE encoding on a regular
basis for our shop. This basically means it stores and retrieves
strings as utf-8 encoded. If you dont need special collating
rules, thats the way to go. However we are using Python/Zope
in front of the DB for presentation and
On Thu, 2003-07-17 at 01:39, Lynna Landstreet wrote:
> I'm running into a bit of trouble with a Unicode-enabled PostgreSQL database
> (some of the data consists of artist and/or image names in other languages,
> like French, Spanish, German and Portuguese, which frequently have accents,
> and I do
On 16 Jul 2003 at 19:09, Kirill Ponazdyr wrote:
> It is for a advanced syslog server product we are currently developing.
>
> The very basic idea is to feed all syslog messages into a DB and allow
> easy monitoring and even correlation, we use Postgres as our DB Backend,
> in big environments the
42 matches
Mail list logo
