Hi
Does Postgresql utilize hyperthreading and multiple cores on the relevant
processors on windows?
Thanks
H.F.
On Mon, Jun 6, 2011 at 4:17 PM, Heine Ferreira heine.ferre...@gmail.comwrote:
Hi
Does Postgresql utilize hyperthreading and multiple cores on the relevant
processors on windows?
Thanks
H.F.
It certainly looks like it on my machine! As far as my Linux box can tell,
the hyperthreaded
: [GENERAL] newbie question
Hi
Does Postgresql utilize hyperthreading and multiple cores on the relevant
processors on windows?
Thanks
H.F.
On 06/07/2011 04:17 AM, Heine Ferreira wrote:
Hi
Does Postgresql utilize hyperthreading and multiple cores on the
relevant processors on windows?
Sort-of. PostgreSQL runs many processes, one per query. Each process has
a single thread. This means that one query can use at most one CPU core,
Grant Mckenzie wrote on 20.11.2010 07:00:
How do people implement insert or upate ( otherwise known as upsert )
behaviour in postgres i.e. insert a row if it's key does not exist in
the database else update the existing row?
You can simply send the UPDATE, if nothing was updated, it's safe to
On 11/20/2010 02:43 PM, Thomas Kellerer wrote:
Grant Mckenzie wrote on 20.11.2010 07:00:
How do people implement insert or upate ( otherwise known as upsert )
behaviour in postgres i.e. insert a row if it's key does not exist in
the database else update the existing row?
You can simply send
How do people implement insert or upate ( otherwise known as upsert ) behaviour
in postgres i.e. insert a row if it's key does not exist in the database else
update the existing row?
I tried using an insert rule to delete any existing rows first then insert
however this leads to infinitely
Hi,
a question that I imagine is a faq but have not been able to find much help.
How do people implement insert or upate ( otherwise known as upsert ) behaviour
in postgres i.e. insert a row if it's key does not exist in the database else
update the existing row?
I tried using an insert rule
Hi,
In the mid 1990's I used the Progress Database which had a great feature
where the it was possible to set the software version in the
configuration file. For example, if you had a built a database and
application using version 3 and then upgraded the version 7, it was
possible to set the
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Russell Aspinwall
Sent: woensdag 17 oktober 2007 9:34
To: pgsql-general@postgresql.org
Subject: [GENERAL] newbie question
Hi,
[snip] For example, if you had a
built a database and application using
-Original Message-
From: Russell Aspinwall [mailto:[EMAIL PROTECTED]
Sent: woensdag 17 oktober 2007 11:37
To: Joris Dobbelsteen
Subject: Re: [GENERAL] newbie question
Joris Dobbelsteen wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
On Tue, 2006-10-10 at 04:16, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/09/06 22:43, Jonathan Greenberg wrote:
So I've been looking at the documentation for COPY, and I'm curious about a
number of features which do not appear to be included, and whether these
On 10/10/06, Jonathan Greenberg [EMAIL PROTECTED] wrote:
So I've been looking at the documentation for COPY, and I'm curious about a
number of features which do not appear to be included, and whether these
functions are found someplace else:
1) How do I skip an arbitrary # of header lines
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/10/06 01:44, Merlin Moncure wrote:
On 10/10/06, Jonathan Greenberg [EMAIL PROTECTED] wrote:
So I've been looking at the documentation for COPY, and I'm curious
about a
number of features which do not appear to be included, and whether these
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/09/06 22:43, Jonathan Greenberg wrote:
So I've been looking at the documentation for COPY, and I'm curious about a
number of features which do not appear to be included, and whether these
functions are found someplace else:
1) How do I
So I've been looking at the documentation for COPY, and I'm curious about a
number of features which do not appear to be included, and whether these
functions are found someplace else:
1) How do I skip an arbitrary # of header lines (e.g. 1 header line) to
begin reading in data?
2) Is it
On Tue, Dec 20, 2005 at 10:21:54PM +0100, Alexander Scholz wrote:
Hi,
is there a newbie's FAQ / book / link for howto optimize databases with
PostgreSQL?
Background: Customer has the Windows* (sorry g) Postgres 8.1.0
standard installation out of the box. A table has 2.5 mio records.
No
Hi,
is there a newbie's FAQ / book / link for howto optimize databases with
PostgreSQL?
Background: Customer has the Windows* (sorry g) Postgres 8.1.0
standard installation out of the box. A table has 2.5 mio records. No
indizes defined, primary key (sequence) does exist. In pgAdmin select
am 20.12.2005, um 22:21:54 +0100 mailte Alexander Scholz folgendes:
Hi,
is there a newbie's FAQ / book / link for howto optimize databases with
PostgreSQL?
07:12 rtfm_please For information about tuning
07:12 rtfm_please see http://www.powerpostgresql.com
07:12 rtfm_please or
Thanks to all who answered this question!
From: Brent Wood [EMAIL PROTECTED]
To: basel novo [EMAIL PROTECTED]
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] newbie question: reading sql commands from script
Date: Wed, 26 Oct 2005 10:36:34 +1300 (NZDT)
On Tue, 25 Oct 2005, basel novo
On Tue, 25 Oct 2005, basel novo wrote:
What is the equivalent of the mysql 'source' command for reading sql
commands from ascii script files?
I have not used mysql, so am not familiar with the source command, but to
have postgres run a set of sql statements/queries from a file you can:
On Mon, 2005-10-24 at 20:39 -0400, Sean Davis wrote:
In psql, look at \i.
Sean
- Original Message -
From: basel novo
To: pgsql-general@postgresql.org
Sent: Monday, October 24, 2005 8:28 PM
Subject: [GENERAL] newbie question: reading
What is the equivalent of the mysql 'source' command for reading sql
commands from ascii script files?
Thanks.
_
Dont just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
Title: [GENERAL] newbie question: reading sql commands from script files
In psql, look at \i.
Sean
- Original Message -
From:
basel
novo
To: pgsql-general@postgresql.org
Sent: Monday, October 24, 2005 8:28
PM
Subject: [GENERAL] newbie question:
reading sql
Hello Tom,
Thank you for the enlightment, I think I understand what you say.
There are however a few things I'm not sure about still. The update
seems to work as I would expect when I include one or more in there where
clause from the primary key. If I have a field not in the primary key
hi,
is it possible to schedule the execution of an sql stored procedure in
postgress on linux?
thanks
Hugo
---(end of broadcast)---
TIP 8: explain analyze is your friend
in the
file that you feed to psql.
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Hugo
Sent: Wednesday, May 18, 2005 8:24 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Newbie question
hi,
is it possible to schedule
IMHO cron would be the best for that...
is it possible to schedule the execution of an sql stored procedure in
postgress on linux?
--
Vlad
---(end of broadcast)---
TIP 6: Have you searched our list archives?
Dear Hugo,
It is possible using cron and psql. Just man cron on unix if you're
not already familiar with that. The command line you should use is
something like:
psql [connection options] -f sql_commands_file.sql
Also man psql for the options you can use...
Starting the procedure should be
Hi Hugo,
Yes, it is possible. Just write an outer perl script(in example), which
to call this stored procedure. Then put in the cron to call whis perl
script. As Far As I Know there isn't other way.
Kaloyan Iliev
Hugo wrote:
hi,
is it possible to schedule the execution of an sql stored
thanks all for your help, I'll try your suggestions
regards
Hugo
2005/5/18, Kaloyan Iliev Iliev [EMAIL PROTECTED]:
Hi Hugo,
Yes, it is possible. Just write an outer perl script(in example), which
to call this stored procedure. Then put in the cron to call whis perl
script. As Far As I
Hugo wrote:
hi,
is it possible to schedule the execution of an sql stored procedure in
postgress on linux?
thanks
Hugo
cron job:
eg. Sat 2:30am
30 2 * * Sat psql -d dbname -c select your_func()
--
___
This e-mail may be privileged and/or confidential, and the sender
Kaloyan Iliev Iliev wrote:
Hi Hugo,
Yes, it is possible. Just write an outer perl script(in example), which
to call this stored procedure. Then put in the cron to call whis perl
script. As Far As I Know there isn't other way.
Depending on whether you want to schedule a procedure on a regular
Hello,
I have been working with a great database system called PostgreSQL for
many years ;-) but never had to use any RULEs. I now have to use and
update through a view and have written a few rules to make this possible
as per the manual.
My insert rules seems to work fine, but I
Leif Jensen [EMAIL PROTECTED] writes:
CREATE RULE update_tasks2taskshead AS
ON UPDATE TO tasks WHERE NEW.seq = 0
DO NOTHING
;
That rule looks a bit useless ...
CREATE RULE update_tasks2ganntinfo AS
ON UPDATE TO tasks
DO INSTEAD (
update ganntinfo set
id = NEW.id, seq =
Please excuse my ignorance of databases and black holes.
I don't have access to a Postgres db right now so I tried an
experiment with mysql. Since they don't have a select into that
creates a table, I tried this:
mysql create table t as ( select * from table_x);
since table_x has no rows, I
Larry White [EMAIL PROTECTED] writes:
mysql create table t as ( select * from table_x);
That works in Postgres too. The SELECT INTO construct is a bit broken
since, as you discovered, it has a different meaning in plpgsql than
in the main SQL language. So I recommend using CREATE TABLE AS when
I wrote a function that returns a rowtype. The rowtype is assigned a
value by a query using SELECT INTO. The query sometimes will return
no rows. When it does, the function's return value is a row with no
values.
I would have expected it to return 0 rows, like the query itself. Am
I doing
Larry White [EMAIL PROTECTED] writes:
I wrote a function that returns a rowtype. The rowtype is assigned a
value by a query using SELECT INTO. The query sometimes will return
no rows. When it does, the function's return value is a row with no
values.
I would have expected it to return 0
Hi guys, I'm wondering what the easy way to grant user/group access on all
tables
in a db. I just migrated about 200 tables from my MySQL database using a cool
migration script, but now all the tables are owned by me in the schema public.
That is all fine and all, but I wish I could run a
On Mon, Nov 08, 2004 at 05:00:49PM -0800, Kenji Morishige wrote:
I'm wondering what the easy way to grant user/group access on all tables
in a db.
This comes up from time to time -- search the archives for phrases
like grant and all tables. The responses usually suggest writing
a script or
Try using EXECUTE.
http://www.postgresql.org/docs/7.4/static/plpgsql-
statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Oct
hi,
I think it works for me. what version of postgres do you have? maybe
you just need to upgrade : )
test=# select cust_id, 'TEST' as test, cust_address from customers;
cust_id | test | cust_address
+--+--
11 | TEST | 200 Maple Lane
On Tue, Oct 26, 2004 at 08:24:56PM -0500, Naeem Bari wrote:
The only way this works in postgres is by casting 'GREEN' to text using
'GREEN'::text
The problem is then this does not work with oracle.
So use a standards-conformant cast, like
cast('GREEN' as text)
--
Alvaro Herrera
I have a simple function defined thusly:
CREATE OR REPLACE FUNCTION datemath(timestamp with time
zone, int4, varchar)
RETURNS timestamp AS
'
DECLARE
tdat timestamp;
rdat timestamp;
BEGIN
IF ($1 IS NULL) THEN
TDAT
:= NOW();
ELSE
TDAT
:= $1;
END IF;
select
tdat +
On Tue, 2004-10-26 at 11:57 -0500, Naeem Bari wrote:
I have a simple function defined thusly:
CREATE OR REPLACE FUNCTION datemath(timestamp with time zone, int4,
varchar)
RETURNS timestamp AS
'
DECLARE
tdat timestamp;
rdat timestamp;
BEGIN
IF ($1 IS NULL)
Thanks! Now I get it...
naeem
-Original Message-
From: Oliver Elphick [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 26, 2004 3:05 PM
To: Naeem Bari
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Newbie question about escaping in a function
On Tue, 2004-10-26 at 11:57 -0500, Naeem
Ok,
I have a query that runs fine in oracle:
select
driver_id, 'GREEN' as color, pos_date,
pos_lat, pos_lon
from
driver_pos
where
driver_id = 1
order
by pos_date
The only way this works in postgres
is by casting GREEN to text using GREEN::text
The problem is then this
The only way this
works in postgres
is by casting GREEN to text using GREEN::text
The problem is
then this does not work with oracle. Since my
software has to support both databases, I am left in a bit of a bind. Any ideas on how to make postgres
accept GREEN
as text without my
Robin 'Sparky' Kopetzky [EMAIL PROTECTED] writes:
How do you pronounce PostgreSQl??
post-gres or post-gres-cue-ell. See item 1.1 of the FAQ ;-)
There used to be a .wav file on the website, but I can't find it
at the moment.
regards, tom lane
Aaron Bratcher wrote:
Is there no way I can do it with a standard select command in a
different client? I don't need the indexes, just the column names/types.
For PostgreSQL 7.3 and above:
SELECT
a.attname,
format_type(a.atttypid, a.atttypmod)
FROM
pg_catalog.pg_class c INNER JOIN
this should work (don't forget to replace TABLE NAME!!!):
SELECT
A.attname,
pg_catalog.format_type(a.atttypid, a.atttypmod) AS typeName
FROM
pg_class C,
pg_attribute A,
pg_type T
WHERE
C.relname ILIKE 'TABLE NAME' AND
(C.oid=A.attrelid) AND
(T.oid=A.atttypid) AND
(A.attnum0)
: Freitag, 6. Februar 2004 15:10
An: [EMAIL PROTECTED]
Betreff: Re: [GENERAL] newbie question... how do I get table
structure?
Is there no way I can do it with a standard select command in a
different client? I don't need the indexes, just the column
names/types.
--
Aaron Bratcher
ab
On Friday 06 February 2004 15:00, Franco Bruno Borghesi wrote:
Does anyone know if the ansi sql standard defines any way to do this?
I've seen the DESCRIBE TABLE/INDEX/... or SHOW TABLE/INDEX/... commands
in other databases, but I don't really know if they are extensions or
not.
There's the
Franco Bruno Borghesi [EMAIL PROTECTED] writes:
Does anyone know if the ansi sql standard defines any way to do this?
I've seen the DESCRIBE TABLE/INDEX/... or SHOW TABLE/INDEX/... commands
in other databases, but I don't really know if they are extensions or
not.
They are extensions (and
On 15. jan 2004, at 18:51, JustSomeGuy wrote:
I want to design a data base that can hold the following structure
struct {
unsigned short a;
unsigned short b;
unsigned int len;
unsigned char *data;
} myObject;
a and b describe the type of object, len is the number of bytes that
I want to design a data base that can hold the following structure
struct {
unsigned short a;
unsigned short b;
unsigned int len;
unsigned char *data;
} myObject;
a and b describe the type of object, len is the number of bytes that
are required to hold the object.
and of course
Victor Spång Arthursson wrote:
Are presently converting from mysql to postgresql, and my first
newbiequestion is how to make all the rows in a result from a select
just swosh by? That is, I dont want to see them page for page; just to
scroll by so I can se the last line with the number of
Are presently converting from mysql to postgresql, and my first
newbiequestion is how to make all the rows in a result from a select
just swosh by? That is, I dont want to see them page for page; just
to scroll by so I can se the last line with the number of corresponding
rows.
And is there a
2003-10-28 kl. 14.33 skrev Jeff:
1. in psql, \pset pager will turn paging off.
Although, if you really want a row count, a much better way to do that
is select count(*) from [rest of select statement]
Thanks.
I'm not new to SQL, just to postgresql, so I know about the
Count-function ;)
Reason
On Wed, Oct 29, 2003 at 01:24:56AM +1100, Brendan Jurd wrote:
from your question that you are), then the results are reported back via
the utility less (or a less-like program internal to psql, can someone
else clarify?)
Actually, it's your $PAGER environment variable (and there's the
usual
On Fri, Aug 24, 2001 at 09:53:00PM +, uncleleo wrote:
I am attemping to create multiple databases with Postgresql ver. 7.0.3
running on Mandrake 8.0 rpm. The tool that I am using is Pgadmin ver 7.1.0.
Can someone tell me how I can connect to different databases in a single
select
On Fri, 24 Aug 2001, uncleleo wrote:
I am attemping to create multiple databases with Postgresql ver. 7.0.3
running on Mandrake 8.0 rpm. The tool that I am using is Pgadmin ver 7.1.0.
Can someone tell me how I can connect to different databases in a single
select statement? Such as, I
Hallo!
How do I create an autoincrement field in a postgresql table???
What are the correct field type and parameters
Well, what about using sequences?
create sequence tralalala;
create table huibui
(
id integer primary key default nextval('tralalala'),
field1 references table1,
Clay Judi Kinney writes:
How do I create an autoincrement field in a postgresql table???
See FAQ.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Cefull Lo writes:
What is the upper limit of OID?
2^31-1
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
On Tue, 10 Apr 2001, Cefull Lo wrote:
When I type INSERT INTO friend
VALUES ('', '', '');
it returns
INSERT 19748 1
what means of 19748 and 1?
19748 is the OID of that record, and 1 means one record was inserted.
For information on OID's, look in the documentation.
--
Dominic J.
When I type INSERT INTO friend
VALUES ('', '', '');
it returns
INSERT 19748 1
what means of 19748 and 1?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
On Sat, 24 Feb 2001, Bela Lantos wrote:
I just started learning Database Design, our programs have to work on
Oracle, but at home I run Linux.
Can any of you tell me how portable are the programs written for Progresql?
Would they run on Oracle without problem?
That all depends on the
hi all,
Is it possible to store java Objects in postgres and
invoke methods on them??. Is it possible to store XML
in postgres?.
please reply ASAP
thanx in adv.
prashanth
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
prashanth bhat [EMAIL PROTECTED] writes:
hi all,
Is it possible to store java Objects in postgres and
invoke methods on them??. Is it possible to store XML
in postgres?.
The answer to both your questions is "yes, but..."
Any Java object that implements Serializable can be serialized into
what do u mean by the datadir problem..
if pg_ctl asks for a datadir then ucan set it in /etc/profile and start
again..
Hope this helps
Anand
On Mon, Jan 08, 2001 at 03:44:34PM +0100, MUMCU, Burak wrote:
Hi all,
I'm using Suse Linux 7.0 and I have installed PostgreSQL. The problem is
when I
ALTER USER postgres WITH PASSWORD '[enter password]'
http://www.postgresql.org/users-lounge/docs/7.0/user/sql-alteruser.htm
- Original Message -
From: "Leon van Dongen" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 18, 2000 1:56 AM
Subject: [GENERAL] newbi
Is there an upper limit on the size of a "text" character field? If so,
how can I extend it?
Thanks,
John
begin:vcard
adr;dom:;;232 E. Lyons;Spokane;WA;99208;
n:Pilley;John
x-mozilla-html:FALSE
org:Settlement Plus, Inc.
version:2.1
email;internet:[EMAIL PROTECTED]
title:Software Engineer
of data
comingled with smaller chunks.
-Nick Fankhauser
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of John Pilley
Sent: Wednesday, November 01, 2000 12:10 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Newbie Question
Is there an upper limit on the size
On Wed, Nov 01, 2000 at 12:32:58PM -0500, Nick Fankhauser wrote:
According to the documentation and Bruce M's book, there is no limit. I've
never hit a limit while putting some pretty large (three page) narratives in
a text field.
There is no limit on the "text" type as such, but there is
Isaac and Tom,
Awesome, thanx. I thought i was doing something wrong. I suggest that some
sort of warning about this go on the pgsql website (and other places where
us PPC types will notice it) so no one else has to beat their head on the
wall over this.
Postgres 7.0.* doesn't work on
* Robert Vogt IV [EMAIL PROTECTED] [001028 12:10]:
[SNIP]
By the way- does anybody know of any resources related to securing
databases. We'd like to only allow certain users access to each database,
but cannot find the appropriate section in any of the documentation pages.
Look at
"Robert Vogt IV" [EMAIL PROTECTED] writes:
Postgres 7.0.* doesn't work on PPC unless compiled -O0. The above is
a typical symptom of being compiled with higher optimization settings.
Unfortunately, it seems that our PPC RPMs for 7.0.2 were compiled with
the wrong -O level :-(. (Don't ask me
Mr. Lane,
Why is this? We're running 7.0.2 and have not performed any of these
compile-time gymnastics...and we're not having any problems
Did you compile from source? If so I'd expect things to be fine. It's
just the PPC RPMs that are (or, shortly, were) on our FTP server that
Awesome, thanx. I thought i was doing something wrong. I suggest that some
sort of warning about this go on the pgsql website (and other places where
us PPC types will notice it) so no one else has to beat their head on the
wall over this.
AP2P
--i
on 10/27/00 10:52 PM, Tom Lane at [EMAIL
is it possible to pull a column from a postgres table then have it linked
via html and php to the corresponding row. If so how would that be
accomplished?
I saw that you can have functions written in C or SQL, but can you write a
precompiled SQL statement (such as SELECT * FROM tablename WHERE ...) that
returns a set of rows? I couldn't find anything that addresses this in the
documentation (does that mean it can't be done yet?).
83 matches
Mail list logo
