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,
PostgreSQL is process based. So it can be configured to use resources as
intensively as you like.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Heine Ferreira
Sent: Monday, June 06, 2011 1:17 PM
To: pgsql-general@postgresql.org
Subject: [GENER
On Mon, Jun 6, 2011 at 4:17 PM, Heine Ferreira wrote:
> 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" CPUs just appear
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 r
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 s
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
>-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
>-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
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
-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
-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 whethe
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
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 ) Postgres 8.1.0
> standard installation "out of the box". A table has 2.5 mio reco
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
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:
p
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: r
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 sq
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 basi
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
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
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 procedu
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
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?
http://archives.pos
Sure. Just set up psql with a SQL script containing your task using a
chron job.
The psql utility will accept a command file as a parameter.
PostgreSQL has functions rather than stored procedures, but it works out
about the same.
You could also put a bunch of SQL commands that you want to run i
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
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
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 w
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,
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 retu
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
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 ()
"T
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
100
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 2
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
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
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
>
>
"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
that's great, I didn't know about the information schema... guess I never read the 'what's new' document
On Fri, 2004-02-06 at 13:15, Tom Lane wrote:
Franco Bruno Borghesi <[EMAIL PROTECTED]> writes:
> Does anyone know if the ansi sql standard defines any way to do this?
> I've seen the DESC
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 (an
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
on Bratcher
> Gesendet: 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 in
this should work (don't forget to replace !!!):
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 '' AND
(C.oid=A.attrelid) AND
(T.oid=A.atttypid) AND
(A.attnum>0) AND
(NOT A.attisd
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
p
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 DataTools
http://www.abDataTools.com
On Feb 6, 2004, at 8:12 AM, Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
"Joshua D. Drake" <[
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
are
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
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
u
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 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 s
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,
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
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,
and
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
subscribe-nomai
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.
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 serialize
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 p
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
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] newbie question
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 s
John-
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. Practically speaking, I would guess that one will take a
performance hit due to fragmentation when storing big chunks of data
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
"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 :-(.
* 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 pg_
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 wo
Isaac <[EMAIL PROTECTED]> writes:
> ERROR: getattproperties: no attribute tuple 1259 -2
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 w
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 PROTEC
67 matches
Mail list logo
