Andreas Kretschmer <[EMAIL PROTECTED]> schrieb:
> Adam <[EMAIL PROTECTED]> schrieb:
>
> >
> > I just emptied my table and I want all my new inserts to start with a
> > 'location_id' of '1'. The table is named "locations" with a SERIAL column
> > "location_id"
> >
> > I tried the below SQL to r
Adam <[EMAIL PROTECTED]> schrieb:
>
> I just emptied my table and I want all my new inserts to start with a
> 'location_id' of '1'. The table is named "locations" with a SERIAL column
> "location_id"
>
> I tried the below SQL to rest the sequence ID but it's not working. What am I
> doing wron
I just emptied my table and I want all my new
inserts to start with a 'location_id' of '1'. The table is named "locations" with a SERIAL column
"location_id"
I tried the below SQL to rest the sequence ID but
it's not working. What am I doing wrong?
SELECT setval('locations_location_id_s
Thank you...I supposed I'll try this one if it could suits my needs.It's really hard to maintain views and functions updates.On 10/11/06, A. Kretschmer
<[EMAIL PROTECTED]> wrote:
am Wed, dem 11.10.2006, um 7:37:11 -0300 mailte Jorge Godoy folgendes:> "Jan Cruz" <[EMAIL PROTECTED]> writes:>> > Is
"J S B" <[EMAIL PROTECTED]> writes:
> well, newDB is the name of the database and that what I'm tryin to connect.
> I'm tryin to keep it the same case in ECPG code as it is in the Database.
> Do u mean to say that combination of upper and lower case is not allowed?
No, I mean to say that names wil
Hi Jef,I use the prototype 1.4 to ajax some web pages. I have to encodeURI the post form data especial the string form value, otherwise the server will receive wrong encoding characters.If you can not see the query result in correct web page encoding, maybe the page container of this XUL ajax contr
well, newDB is the name of the database and that what I'm tryin to connect. I'm tryin to keep it the same case in ECPG code as it is in the Database.
Do u mean to say that combination of upper and lower case is not allowed?
in newDB , 'new' is all lower case and 'DB' is all upper.
Thanks,
Jas
On
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Thomas Kellerer
> Sent: Friday, October 13, 2006 2:11 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] more anti-postgresql FUD
>
> [EMAIL PROTECTED] wrote on 11.10.2006 16:
"J S B" <[EMAIL PROTECTED]> writes:
> The user in the client machine is usrxyz (a unix user role) and user role
> that owns newDB is userxyz (a db user role)
I notice you keep spelling it as "newDB" ... is there a case-folding
issue here perhaps?
regards, tom lane
---
[EMAIL PROTECTED] wrote on 11.10.2006 16:54:
Do a simple test to see my point:
1. create table test (id int4, aaa int4, primary key (id));
2. insert into test values (0,1);
3. Execute "update test set aaa=1 where id=0;" in an endless loop
As others have pointed out, committing the data is a vi
am Thu, dem 12.10.2006, um 18:40:22 -0700 mailte Niederland folgendes:
> I am using postgresql 8.1.4.
>
> Is there anyway to create an index equivalent to:
> CREATE INDEX i1 ON t1 USING btree (ts::Date);
CREATE INDEX i1 ON t1 USING BTREE (to_char(ts, 'dd-mm-' ));
*untested*
Please, let m
"Niederland" <[EMAIL PROTECTED]> writes:
> I am using postgresql 8.1.4.
> Is there anyway to create an index equivalent to:
> CREATE INDEX i1 ON t1 USING btree (ts::Date);
You're short some parentheses:
CREATE INDEX i1 ON t1 USING btree ((ts::Date));
regards, tom lane
jef peeraer wrote:
i never thought i would be bblocked by an encoding problem :-(
My database is in LATIN1 , i have entries like this in a table called
gemeenten
Column | Type | Modifiers
---+--+--
SISTEMAS wrote:
> El backend de Postgres (el programa ejecutable postgres real) lo puede
> ejecutar el superusuario directamente desde el intérprete de órdenes de
> usuario de Postgres (con el nombre de la base de datos como un argumento).
> Sin embargo, hacer esto elimina el buffer pool compartido
On Thu, Oct 12, 2006 at 02:29:27PM -0700, Stuart Morse wrote:
> Hi,
>
> I've written a set of functions in C that will ultimately be called from an
> enterprise java bean. I expected that when calling SPI_exec(sql, 0) it would
> return an error code if "sql" contained a syntax error. At that point
On Thu, Oct 12, 2006 at 06:40:22PM -0700, Niederland wrote:
> I am using postgresql 8.1.4.
>
> Is there anyway to create an index equivalent to:
> CREATE INDEX i1 ON t1 USING btree (ts::Date);
>
> So that indexes are used for queries when the field is cast to a date.
I didn't try it, but you ou
> Face it, if one does hundreds updates per second for one table (that's
> exactly what ZABBIX does, and not for one record(!) table as in my
> simple test), performance degrades so fast that vacuum has to be
> executed once per 5-15 seconds to keep good performance. The vacuum
> will run at least
Hello,
I want to increase the max_connections of PostgreSQL from around 40 to
around 100. For this I need to change the Shared Memory and Semaphores
settings.
I followed this link -
http://www.postgresql.org/docs/8.1/interactive/kernel-resources.html#SYSVIPC
and used the proposed values in
> it would be cool if you could at least:
>
> - bundle your updates into transactions of, say, 1000 updates at a time
>i.e. wrap a BEGIN; END; around a 1000 of them
> - run postgresql with fsync off, since you're using MyISAM
> - run PostgreSQL at least 8, since you're running MySQL 5
>
> I'
In article <[EMAIL PROTECTED]>,
Albe Laurenz <[EMAIL PROTECTED]> wrote:
% > How can I check for the
% > presence of constraints inside a function?
%
% select t.oid as tableid, t.relname as tablename,
% c.oid as constraintid, conname as constraintname
% f
I am new to postgres and I have 4 doubts. 1) I have a performance problem as I am trying to insert around 60 million rows to a table which is partitioned. So first I copied the .csv file which contains data, with COPY command to a temp table which was quick. It took only 15 to 20 minutes. Now I
El
backend de Postgres (el programa ejecutable postgres
real) lo puede ejecutar el superusuario directamente desde el intérprete
de órdenes de usuario de Postgres (con el
nombre de la base de datos como un argumento). Sin embargo, hacer esto elimina
el buffer pool compartido y bloquea la t
Hi,
I’ve written a set of functions in C that will
ultimately be called from an enterprise java bean. I expected that when calling
SPI_exec(sql, 0) it would return an error code if “sql” contained a
syntax error. At that point I would be able to return my own (more meaningful)
error mes
I am using postgresql 8.1.4.
Is there anyway to create an index equivalent to:
CREATE INDEX i1 ON t1 USING btree (ts::Date);
So that indexes are used for queries when the field is cast to a date.
---(end of broadcast)---
TIP 4: Have you searched
On Fri, Oct 13, 2006 at 01:35:51PM -0400, Tom Lane wrote:
> looked reasonably robust --- ie, both safe and not full of unsupportable
> assumptions about knowing exactly where everything actually is on the
> disk platter. It'd still be interesting if anyone gets a new idea...
Might it be the case
Martijn van Oosterhout wrote:
On Thu, Oct 12, 2006 at 11:09:53PM +0200, Tomi NA wrote:
2006/10/12, Martijn van Oosterhout :
On Tue, Oct 10, 2006 at 11:49:06AM +0300, Martins Mihailovs wrote:
There are some misunderstood. Im using Linux 2.6.16.4, postgresql 8.1.4,
(there are one of locale: lv
I tried to use O_DIRECT on Linux (SuSe) Kernel 2.6, but failed to make it run.
For example, if I added the option in the "open" of BasicOpenFile(),
I got the following error after typing "psql -l",
psql: could not connect to server: Connection refused
Is the server running locally and accep
Hi,
I am searching a installer tool for linux / apache / pgsql / php
[which is like WAMP or, XAMPP (on linux)].
is there any tool which is avaliable on net.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http:
Thanks for the answer!
We'll order a 2 x Opteron2xxx series (Dual Core) and the memory will be
16-32 Gb. This server is only for DB - non other services such as hosting,
mail and so on.
I'm not system integrator, but the project manager and interesting about:
- existing the free OS that ideally s
> > Unfortunately PostgreSQL performs much slower than MySQL doing large
> > number of updates for one single table. By its nature ZABBIX requires
> > to execute hundreds of updates per second for large installations.
> > PostgreSQL cannot handle this nicely.
>
> If you refuse to vacuum (or have th
> > I'm author and maintainer of ZABBIX and the manual. I would like to add
> > some comments to the thread.
>
> just so you know, I brought this up after taking a look at the zabbix
> software, which is in my opinion very excellent. I came across a
> little strong in my comments and peter e was c
> > 1. create table test (id int4, aaa int4, primary key (id));
> > 2. insert into test values (0,1);
> > 3. Execute "update test set aaa=1 where id=0;" in an endless loop
> >
> > I just did the test on PostgreSQL 7.4.12 and MySQL 5.0.22 (MyISAM,
> > sorry had no configured InnoDB). Ubuntu 6.0.6, A
Jonathan Vanasco wrote:
I made a HUGE mistake, and used 'UK' as the abbreviation for the
united kingdom ( the ISO abbv is 'GB' )
I've got a database where 8 tables have an FKEY on a table
'location_country' , using the text 'uk' as the value -- so i've got
9 tables that I need to swap d
>
> 2. less points of failure: ups doesnt help you if your cpu fries,
> power supply fries, memory frieds, motherboard fries, o/s halts, etc
> etc. :-)
>
> 3. experience has taught me not to put 100% faith in ups power switchover.
As a follow up to this. We have all line conditioning natural gas
On 10/13/06, AgentM <[EMAIL PROTECTED]> wrote:
> No to mention if you are *that* concerned you could buy a generator
> for
> 500 bucks that will keep the machine alive if you absolutely have to.
>
> There is nothing wrong with write back cache as long as you have the
> infrastructure to support i
On Oct 13, 2006, at 14:36 , Joshua D. Drake wrote:
Stephen Frost wrote:
* Alexander Staubo ([EMAIL PROTECTED]) wrote:
What formula did you use to get to that number? Is there a generic
way on Linux to turn off (controller-based?) write caching?
Just a side-note, but if you've got a pretty g
The only diff b/w the two DBs is that the one getting connected has ACL value as blank and the one that doesn't get connected has the same ACL property values = {}On 10/13/06,
Shane Ambler <[EMAIL PROTECTED]> wrote:
J S B wrote:> Hi,> I took a back up of my database and restored it in a new DB..W
The user in the client machine is usrxyz (a unix user role) and user role that owns newDB is userxyz (a db user role)works fine with another database in the same database server with same user role combination.
Don't know whats going wrong..On 10/13/06, Shane Ambler <[EMAIL PROTECTED]> wrote:
J
On Fri, 2006-10-13 at 13:07 -0500, Jim C. Nasby wrote:
> On Fri, Oct 13, 2006 at 01:52:10PM -0400, Merlin Moncure wrote:
> > On 10/13/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> > >Martijn van Oosterhout writes:
> > >> Is that really true? In theory block n+1 could be half a revolution
> > >> after
On Fri, 2006-10-13 at 12:48, Jim C. Nasby wrote:
> On Thu, Oct 12, 2006 at 05:39:20PM -0500, Scott Marlowe wrote:
> > > > It seems to me the first logical step would be having the ability to
> > > > flip a switch and when the postmaster hits a slow query, it saves both
> > > > the query that ran lo
Stephen Frost wrote:
> * Alexander Staubo ([EMAIL PROTECTED]) wrote:
>> What formula did you use to get to that number? Is there a generic
>> way on Linux to turn off (controller-based?) write caching?
>
> Just a side-note, but if you've got a pretty good expectation that you
> won't be without
* Alexander Staubo ([EMAIL PROTECTED]) wrote:
> What formula did you use to get to that number? Is there a generic
> way on Linux to turn off (controller-based?) write caching?
Just a side-note, but if you've got a pretty good expectation that you
won't be without power for 24 consecutive hours
J S B wrote:
Hi,
I took a back up of my database and restored it in a new DB..When I'm
trying
to connect to the new DB from a client machine using ECPG connection
techniques, it says newDB doesn't exist.
There's another DB in the same DB server and if I try and connect to
that DB
then it does
brian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> I'm betting that's really a Parse protocol message, not a PREPARE
>> statement as such (the 8.1 logging code misguidedly tries to obscure the
>> difference). The logging of the subsequent Bind/Execute messages is
>> really weak in existing rel
Tom Lane wrote:
brian <[EMAIL PROTECTED]> writes:
Sorry--i hadn't had time to run a test. Setting it to 'all' works fine,
and i think i see the problem: the second INSERT is in a prepared
statement, so it's not being logged.
PREPARE mdb2_statement_pgsql00fb05c2c509aa2608b68bf2b87693a2 AS IN
On Fri, Oct 13, 2006 at 01:52:10PM -0400, Merlin Moncure wrote:
> On 10/13/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> >Martijn van Oosterhout writes:
> >> Is that really true? In theory block n+1 could be half a revolution
> >> after block n, allowing you to commit two transactions per revolution.
On Fri, 2006-10-13 at 13:52 -0400, Merlin Moncure wrote:
> On 10/13/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> > Martijn van Oosterhout writes:
> > > Is that really true? In theory block n+1 could be half a revolution
> > > after block n, allowing you to commit two transactions per revolution.
> >
Hi,I took a back up of my database and restored it in a new DB..When I'm trying to connect to the new DB from a client machine using ECPG connection techniques, it says newDB doesn't exist.There's another DB in the same DB server and if I try and connect to that DB then it doesn't cry over anything
On Fri, 2006-10-13 at 09:42 -0700, Bob Pawley wrote:
> I have a trigger that produces an error "returns more than one row".
>
> My intent is to fill one table (library.specification) from another
> (p_id.specification). The p_id table can have multiple instances of
> the same fluid but I want the
The only case I can think of where view partitioning makes more sense is
if it's list partitioning where you can also drop a field from your
tables. IE: if you have 10 projects, create 10 project_xx tables where
xx is the ID of the project, UNION ALL them together in a view, and
create rules on tha
On 10/13/06, Tom Lane <[EMAIL PROTECTED]> wrote:
Martijn van Oosterhout writes:
> Is that really true? In theory block n+1 could be half a revolution
> after block n, allowing you to commit two transactions per revolution.
Not relevant, unless the prior transaction happened to end exactly at a
On Fri, Oct 13, 2006 at 11:53:15AM -0400, AgentM wrote:
> One simple first step would be to run an ANALYZE whenever a
> sequential scan is executed. Is there a reason not to do this? It
Yes. You want a seqscan on a small (couple pages) table, and ANALYZE has
a very high overhead on some platfo
On Thu, Oct 12, 2006 at 05:39:20PM -0500, Scott Marlowe wrote:
> > > It seems to me the first logical step would be having the ability to
> > > flip a switch and when the postmaster hits a slow query, it saves both
> > > the query that ran long, as well as the output of explain or explain
> > > ana
Martijn van Oosterhout writes:
> On Fri, Oct 13, 2006 at 03:35:37PM -, Andrew - Supernews wrote:
>> It's just the number of disk revolutions per second. Without caching, each
>> WAL flush tends to require a whole revolution unless the on-disk layout of
>> the filesystem is _very_ strange.
> I
Harpreet Dhaliwal wrote:
Hi,
Yesterday I configured a postgres server using Pgadmin3, restored the
database from a backup.
Today when i come and check my pgadmin, i can't see any server added there.
Kind of confused.
Can anyone please let me know whats happeneing here and what should i do to
see
Martijn van Oosterhout writes:
> Characters havn't fitted in an unsigned char in a very long time. It's
> obviously bogus for any multibyte encoding (the code even says so). For
> such encodings you could use the system's towupper() (ANSI C/Unix98)
> which will work on any unicode char.
http://de
brian <[EMAIL PROTECTED]> writes:
> Sorry--i hadn't had time to run a test. Setting it to 'all' works fine,
> and i think i see the problem: the second INSERT is in a prepared
> statement, so it's not being logged.
> PREPARE mdb2_statement_pgsql00fb05c2c509aa2608b68bf2b87693a2 AS INSERT
> INTO
On Fri, Oct 13, 2006 at 03:35:37PM -, Andrew - Supernews wrote:
> It's just the number of disk revolutions per second. Without caching, each
> WAL flush tends to require a whole revolution unless the on-disk layout of
> the filesystem is _very_ strange. You can get multiple commits per WAL
> fl
On Fri, Oct 13, 2006 at 12:04:02PM -0400, Tom Lane wrote:
> "Tomi NA" <[EMAIL PROTECTED]> writes:
> > 2006/10/13, Martijn van Oosterhout :
> >> Similarly, upper/lower are also supported, although postgresql doesn't
> >> take advantage of the system support in that case.
>
> > I think this is the c
Bruce Momjian wrote:
brian wrote:
I changed my postgresql.conf to have:
log_statement = mod
It appears to be working, though not logging *all* INSERTs. For
instance, I have a PHP class that inserts into two tables in a
transaction. The log shows the first, but not the second. Has anyone
se
The machine did boot and PostgreSQL started backup, etc.
Thanks.
- Original Message -
From: "Joshua D. Drake" <[EMAIL PROTECTED]>
To: "Brian J. Erickson" <[EMAIL PROTECTED]>
Cc: "PostgreSQL Mailing lists"
Sent: Friday, October 06, 2006 9:17 AM
Subject: Re: [GENERAL] PostgreSQL Database
I have a trigger that produces an error "returns more than
one row".
My intent is to fill one table (library.specification)
from another (p_id.specification). The p_id table can have multiple instances of
the same fluid but I want the library table to have only one record of each
fluid.
On Fri, 2006-10-06 at 23:09 +0200, Ivan Sergio Borgonovo wrote:
> Is there any good documentation, example, tutorial, pamphlet, discussion...
> to exploit pg features to obtain "polymorphic" behavior without renouncing to
> referential integrity?
>
> Inheritance seems *just* promising.
>
> Any
"Tomi NA" <[EMAIL PROTECTED]> writes:
> 2006/10/13, Martijn van Oosterhout :
>> Similarly, upper/lower are also supported, although postgresql doesn't
>> take advantage of the system support in that case.
> I think this is the crux of the problem.
If it were true, then it might be ...
On Oct 13, 2006, at 11:47 , John D. Burger wrote:
Erik Jones wrote:
Forgive me if I'm way off here as I'm not all that familiar with
the internals of postgres, but isn't this what the genetic query
optimizer discussed the one of the manual's appendixes is supposed
to do.
No - it's not
Hi,Yesterday I configured a postgres server using Pgadmin3, restored the database from a backup.Today when i come and check my pgadmin, i can't see any server added there.Kind of confused.Can anyone please let me know whats happeneing here and what should i do to see the server that I added yesterd
On 2006-10-13, Alexander Staubo <[EMAIL PROTECTED]> wrote:
> Makes sense. However, in this case I was batching updates in
> transactions and committing each txn at 1 second intervals, all on a
> single connection. In other words, the bottleneck illustrated by this
> test should not be related
Erik Jones wrote:
Forgive me if I'm way off here as I'm not all that familiar with
the internals of postgres, but isn't this what the genetic query
optimizer discussed the one of the manual's appendixes is supposed
to do.
No - it's not an "optimizer" in that sense. When there are a small
On Oct 13, 2006, at 17:35 , Andrew - Supernews wrote:
On 2006-10-13, Alexander Staubo <[EMAIL PROTECTED]> wrote:
On Oct 13, 2006, at 17:13 , Andrew - Supernews wrote:
Your disk probably has write caching enabled. A 10krpm disk
should be
limiting you to under 170 transactions/sec with a singl
2006/10/13, Martijn van Oosterhout :
While sorting for multiple languages simultaneously is an issue, that's
not the problem here. Linux/GLibc *does* support correct sorting for
all language/charset combinations, and that's what he's using. Just for
the hell of it I setup lv_LV.utf8 on my laptop
On 2006-10-13, Alexander Staubo <[EMAIL PROTECTED]> wrote:
> On Oct 13, 2006, at 17:13 , Andrew - Supernews wrote:
>> Your disk probably has write caching enabled. A 10krpm disk should be
>> limiting you to under 170 transactions/sec with a single connection
>> and fsync enabled.
>
> What formula d
On 10/13/06, Roman Neuhauser <[EMAIL PROTECTED]> wrote:
# [EMAIL PROTECTED] / 2006-10-10 14:16:19 -0400:
> FUD from another open source project is really poor form, particulary
> when not in competing segements where a little bit of competitive
> rivalry is expected.
OMG WTF what FUD???
pl
On Oct 13, 2006, at 17:13 , Andrew - Supernews wrote:
On 2006-10-13, Alexander Staubo <[EMAIL PROTECTED]> wrote:
On my box (Dell PowerEdge 1850, dual Xeon 2.8GHz, 4GB RAM, 10kRPM
SCSI, Linux 2.6.15, Ubuntu) I get 1,100 updates/sec, compared to
10,000 updates/sec with MySQL/InnoDB, using a stock
On 2006-10-13, Alexander Staubo <[EMAIL PROTECTED]> wrote:
> On my box (Dell PowerEdge 1850, dual Xeon 2.8GHz, 4GB RAM, 10kRPM
> SCSI, Linux 2.6.15, Ubuntu) I get 1,100 updates/sec, compared to
> 10,000 updates/sec with MySQL/InnoDB, using a stock installation of
> both. Insert performance is
On Oct 11, 2006, at 16:54 , [EMAIL PROTECTED] wrote:
I'm author and maintainer of ZABBIX and the manual. I would like to
add
some comments to the thread.
[snip]
I just did the test on PostgreSQL 7.4.12 and MySQL 5.0.22 (MyISAM,
sorry had no configured InnoDB). Ubuntu 6.0.6, AMD64, 2GB, defau
Forgive me if I'm way off here as I'm not all that familiar with the
internals of postgres, but isn't this what the genetic query optimizer
discussed the one of the manual's appendixes is supposed to do. Or, is
that more about using the the known costs of atomic operations that make
up a query
On Thu, Oct 12, 2006 at 04:40:32PM +0200, Ivan Sergio Borgonovo wrote:
> Anyway it doesn't solve the problem of having lists that
> can contain different elements with same parent and maintain
> ref. integrity.
Only to some degree.
You can put a unique constraint and a serial default on the
paren
# [EMAIL PROTECTED] / 2006-10-10 14:16:19 -0400:
> FUD from another open source project is really poor form, particulary
> when not in competing segements where a little bit of competitive
> rivalry is expected.
OMG WTF what FUD???
# [EMAIL PROTECTED] / 2006-10-10 13:55:57 -0400:
> http://www
On Fri, Oct 13, 2006 at 03:40:17PM +0200, Tomi NA wrote:
> This is a reoccurring topic on the list: sure, it's possible to
> misconfigure pg so that uppercase/lowercase/ilike/tsearch2/order don't
> work with a single letter outside of the English alphabet, but the
> problem Martins seems to be faci
On 2006-10-13, "Albe Laurenz" <[EMAIL PROTECTED]> wrote:
> You lock the table (with LOCK) or the row you're working on
> (with SELECT FOR UPDATE) so that nobody else can change it while
> you are working on it.
>
> You need something like ctid if your table has the fundamental flaw
> of lacking a p
On 10/13/06, Jean-Christophe Roux <[EMAIL PROTECTED]> wrote:
Thanks for the "ctid" trick. The code below worked fine
for rec in select * from fromemail_trades loop
update fromemail_trades set recordid = row where ctid = rec.ctid;
row := row -1;
end loop;
The first line is
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, I'm from an alternative universe and I'm trying to install
Postgresql 6.12. When will 6.13 be available?
It's in the /extras/postgres directory on the eighth
installation DVD of Duke Nukem Forever.
Greg's mostly
Thanks for the "ctid" trick. The code below worked fine for rec in select * from fromemail_trades loop update fromemail_trades set recordid = row where ctid = rec.ctid; row := row -1; end loop;The first line is a little different from your's: FOR row IN SELECT ctid, * FROM ta
2006/10/13, Martijn van Oosterhout :
On Thu, Oct 12, 2006 at 11:09:53PM +0200, Tomi NA wrote:
> 2006/10/12, Martijn van Oosterhout :
> >On Tue, Oct 10, 2006 at 11:49:06AM +0300, Martins Mihailovs wrote:
> >> There are some misunderstood. Im using Linux 2.6.16.4, postgresql 8.1.4,
> >> (there are
On 10/13/06, Ron Johnson <[EMAIL PROTECTED]> wrote:
Hi,
I've gotten preliminary approval to buy a server and load a *lot* of
data into it. One table will eventually have 4.5Bn 330 bytes rows,
the other 9Bn 300 byte rows. Other will "only" have a billion rows.
They are easily partitioned by yy
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Hi, I'm from an alternative universe and I'm trying to install
> Postgresql 6.12. When will 6.13 be available?
It's in the /extras/postgres directory on the eighth
installation DVD of Duke Nukem Forever.
- --
Greg Sabino Mullane [EMAIL PROTECTED
am Fri, dem 13.10.2006, um 8:40:54 -0400 mailte Geoffrey folgendes:
> Hi, I'm from an alternative universe and I'm trying to install
> Postgresql 6.12. When will 6.13 be available?
Huch?
>
> Sorry, couldn't resist...
;-)
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47215, D
Hi, I'm from an alternative universe and I'm trying to install
Postgresql 6.12. When will 6.13 be available?
Sorry, couldn't resist...
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Fra
> 3) I want to use materialized views, I don?t understand it from
> http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html, can
> anyone explain me
> with a simple example.
The following link helps to describe the idea behind each of the methods of
Materialize views.
http://ja
Rafal Pietrak wrote:
>> You might use 'ctid' to identify the row if you have no suitable
>
> How should I use 'ctid'? Like in the case, when I've selected
> something by means of SELECT ... FOR UPDATE?
You lock the table (with LOCK) or the row you're working on
(with SELECT FOR UPDATE) so that n
Ron,Even though using a view means that it would have to be recreatedeach period as the oldest table is dropped,
please keep in mind: views are not really "created" ... also the command is named "create view"VIEWS, at least in PostgreSQL (and Oracle) are nothing else then "macros" for Queries - th
am Fri, dem 13.10.2006, um 12:47:09 +0300 mailte Uyelik folgendes:
>
> A. Kretschmer wrote, On 13.10.2006 12:32:
>
> am Fri, dem 13.10.2006, um 12:25:38 +0300 mailte Uyelik folgendes:
>
>
> Hi,
> Is there any way to execute a function upon a new connection made or
> exist
Hi,
I've gotten preliminary approval to buy a server and load a *lot* of
data into it. One table will eventually have 4.5Bn 330 bytes rows,
the other 9Bn 300 byte rows. Other will "only" have a billion rows.
They are easily partitioned by mm, which we call FISCAL_PERIOD.
(In fact, the app
A. Kretschmer wrote, On 13.10.2006 12:32:
am Fri, dem 13.10.2006, um 12:25:38 +0300 mailte Uyelik folgendes:
Hi,
Is there any way to execute a function upon a new connection made or existing
one closed?
IIRC no, but you can set variables, perhaps this will help you.
AL
am Fri, dem 13.10.2006, um 12:25:38 +0300 mailte Uyelik folgendes:
> Hi,
> Is there any way to execute a function upon a new connection made or existing
> one closed?
IIRC no, but you can set variables, perhaps this will help you.
ALTER name SET parameter { TO | = } { value | DEFAULT }
> Is act
Hi,
Is there any way to execute a function upon a new connection made or
existing one closed?
Is active connections info stored on a table or (?) ?
Regards,
Mustafa
i never thought i would be bblocked by an encoding problem :-(
My database is in LATIN1 , i have entries like this in a table called
gemeenten
Column | Type | Modifiers
---+--+
id
am Fri, dem 13.10.2006, um 1:55:06 -0700 mailte Uwe C. Schroeder folgendes:
> > Does the table you're inserting into have indexes or foreign keys?
> > Either of those slow down loading considerably. One commen workaround
> > is to drop the indexes and constraints, load the data and re-add them.
>
On Friday 13 October 2006 01:22, Martijn van Oosterhout wrote:
> > 1) I have a performance problem as I am trying to insert around 60
> > million rows to a table which is partitioned. So first I copied the
> > .csv file which contains data, with COPY command to a temp table
> > which was qu
On Fri, 2006-10-13 at 09:23 +0200, Albe Laurenz wrote:
> You might use 'ctid' to identify the row if you have no suitable
How should I use 'ctid'? Like in the case, when I've selected something
by means of SELECT ... FOR UPDATE?
--
-R
---(end of broadcast)--
1 - 100 of 104 matches
Mail list logo
