Steve - DND napisa(a):
Simple question I'm sure, but how can I get the transaction ID that a query
is currently running in? I can find all kinds of documentation talking about
transaction ids, but nothing about how to get the current one.
You can compile attached function - this will return
go wrote:
Hi,
After about 2 month of greate work, my database (running under
PG 8.01 on Win2000) very slow.Reindexing all tables, Vacuum Full,Freeze
and Analyze didn't help(i did it from pg_admin III).
But after dropdb and pg_restore it become fast again.
(The same database -both very
# [EMAIL PROTECTED] / 2005-06-11 08:44:32 -0400:
Hi everybody
I am trying to write a stored procedure that returns a result set but it is
not working
this is the function:
///
CREATE OR REPLACE FUNCTION
remisiones.fn_get_total_remitidoxprovision1(numeric)
RETURNS SETOF record AS
Dear all,
I am having multiple applications that use PostgreSQL
as their database server. These applications are not
related and contains different functionality.
In the past I have been creating a database in the
same database cluster.
Now I am wondering whether it would not be better to
have
I am getting a number of deadlock errors in my log files and I was
wondering if anyone knows how I can stop them.
Query failed: ERROR: deadlock detected DETAIL: Process 11931 waits for
ShareLock on transaction 148236867; blocked by process 11932. Process
11932 waits for ShareLock on
Gavin,
Are you ordering the updates by id inside one transaction ? You should
order the execution of the statements by id inside a transaction, and
the deadlocks should go away.
HTH,
Csaba.
On Wed, 2005-06-15 at 13:10, Gavin Love wrote:
I am getting a number of deadlock errors in my log files
Hi.
Thank you for information. How can I dump_all from pgAdmin III ?
Thanks.
- Original Message -
From: John DeSoi [EMAIL PROTECTED]
To: Zlatko Mati [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Wednesday, June 15, 2005 1:25 AM
Subject: Re: [GENERAL] user groups
On Jun
Hi.
Concerning Egyd's question, I also wanted to ask about setting expiration
date for database. But, I would like to set validity in sense of certain
actions.
For example, I would like to prevent adding new records after expiration,
but would allow viewing existing records
Is there any
Hi,
Actually, if you've multiple installations of
postgreSQLs in different locations, you can start them
simultaneously. And for different clients to connect
to different server instances, you should change the
default port setting.
Changyu
--- Danny Gaethofs [EMAIL PROTECTED] wrote:
Dear
Hi Csaba,
I am not ordering them by ID as in reality the where condition is more
complex than in my example
UPDATE stats SET click_count = click_count+1 WHERE month = '06' AND year
= '2005' AND type = 'a' AND id = '123' AND count_type = 'b';
Can you explain why sorting by ID would make a
Because I guess id is your primary key, and that would make your
transactions always update the same rows in the same order. It really
doesn't matter if you have other criteria in the where clause, the
issuing order of the statements is the problem.
Deadlock will occur if 2 concurrent transactions
Guys,
My company is migrating from a Progress-based ERP system to a PostgreSQL
based system.
We know PostgreSQL from a development standpoint, but not from an admin
perspective. I'd like to hire a consultant to help us with some important
projects, specifically benchmarking Progress versus
John Wells wrote:
Can anyone recommend a very knowledgeable, experienced (yet reasonable)
PostgreSQL consulting firm?
You'll be wanting to state your country/region too.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 7: don't
Richard Huxton said:
John Wells wrote:
Can anyone recommend a very knowledgeable, experienced (yet reasonable)
PostgreSQL consulting firm?
You'll be wanting to state your country/region too.
The company is located in Greensboro, NC, USA. Although on-site consulting
is preferred, it's not a
Hello!
I faced with the fact PG parses some of my queries very slowly.
I mean VERY VERY slowly (for example, MS SQL is about 50 times
faster here).
I used this script for small investigation.
==
#!/usr/bin/perl
use IPC::Open3;
my $cmd = psql -d template1;
sub execute
{
my($txt, $i) =
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 15 Jun 2005, John Wells wrote:
Can anyone recommend a very knowledgeable, experienced (yet reasonable)
PostgreSQL consulting firm?
http://www.postgresql.org/support/professional_support
Regards,
- --
Devrim GUNDUZ
On Tue, 2005-06-14 at 22:55, go wrote:
Hi,
After about 2 month of greate work, my database (running under
PG 8.01 on Win2000) very slow.Reindexing all tables, Vacuum Full,Freeze
and Analyze didn't help(i did it from pg_admin III).
But after dropdb and pg_restore it become fast again.
Hi All,
Are there better open source reporting tools than openrpt, agata?
Thanks,
Hrishi
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
On Tue, 2005-06-14 at 19:03, Bruce Momjian wrote:
Steve - DND wrote:
Let's pretend I don't know how to do that. :) Do you have a
link to a page
in the manual that describes this process, or can you give me a quick
runthrough of what you're talking about?
Every row has an
On Wed, Jun 15, 2005 at 13:34:39 +0200,
Zlatko Mati? [EMAIL PROTECTED] wrote:
Hi.
Concerning Együd's question, I also wanted to ask about setting expiration
date for database. But, I would like to set validity in sense of certain
actions.
For example, I would like to prevent adding new
Hi,
We've been using a 4 CPU Opteron (16GB) for the past several months, and
have now upgraded to an 8 CPU machine with 32GB. Basically, we've taken
the postgresql.conf from the 4 way, and used that in the 8 way without
making any changes. Shared memory for postgresql in both machines is
Csaba Nagy [EMAIL PROTECTED] writes:
Can you explain why sorting by ID would make a difference as I don't
understand why what you are suggesting should make a difference?
Because I guess id is your primary key, and that would make your
transactions always update the same rows in the same
for java programming, yes, it's ireport that handles jasperreport engine.
2005/6/15, Hrishikesh Deshmukh [EMAIL PROTECTED]:
Hi All,
Are there better open source reporting tools than openrpt, agata?
Thanks,
Hrishi
---(end of broadcast)---
If the deadlocks occur because different transactions actually try to
update the same rows concurrently, then this is an appropriate solution.
However I wonder if Gavin is getting bitten by foreign key deadlocks.
Is there any foreign key reference from the stats table to other tables?
Tom,
On Wed, Jun 15, 2005 at 09:51:53AM -0400, Hrishikesh Deshmukh wrote:
Hi All,
Are there better open source reporting tools than openrpt, agata?
Not unless you like Java.
If Java is your thing then JasperReports (and it's various GUI designers)
aren't bad, but it looks like BIRT
I am getting the following error when i try to
install the postgres 8.03 . It seems to be problem with the installing postgres
libs. Plesae advice me to fix this problem.
warning: postgresql-libs-8.0.3-1PGDG.i686.rpm: V3
DSA signature: NOKEY, key ID 748f7d0eerror: Failed
dependencies:
Ilja Golshtein [EMAIL PROTECTED] writes:
I faced with the fact PG parses some of my queries very slowly.
I mean VERY VERY slowly (for example, MS SQL is about 50 times
faster here).
I used this script for small investigation.
Seems to be mostly fixed already. Using your script, I get
PG
hi,
let me explain what I have done, and what I'd like to do with a small example:
create table test (id serial, nom varchar(32));
INSERT INTO test (nom) values ('cedric');
INSERT INTO test (nom) values ('felix');
INSERT INTO test (nom) values ('julien');
create table new_test (id serial, nom
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 15 Jun 2005, Prasad Duggineni wrote:
I am getting the following error when i try to install the postgres 8.03 . It
seems to be problem with the installing postgres libs. Plesae advice me to fix
this problem.
warning:
Hi.
I would like to implement simple users/user groups
administration from MS Access. I have already set user groups and permissions to
different objects inside the database. Now, I would like to enable creating new
users and putting them in previosly pre-defined groups, through Access
Hello.
Till now I've been working with Postgres only
through pgAdminIII. Postgres is installed on WIndows XP.
Now I need to use pg_dumpall. I have found folder
with different Postgres aplications, placed inC:\Program
Files\PostgreSQL\8.0\bin.
When I double-click on any of them, I am
Hi.
I know that superusers are allowed to do everything
on the database, but I consider this as dangerous. I want to have some
user group with rights of creating new users and giving them some
authorizations, but without such wide power as superusers have. So,
I wasthinking about two
Cedric BRINER wrote:
the idea is to drop the ``old_test'' table. But before doing this,
I'd like to alter the table ``test'' to use the sequence
``test_id_seq'' instead of ``test_new_seq_id''?
ALTER TABLE new_table ALTER COLUMN my_column DROP DEFAULT;
ALTER TABLE new_table ALTER COLUMN
I have three scripts that I am running to do pg_dumpall and a vacuum on
my server.
one is run every night except Sundays.
one is run every Sunday night.
one is run the first of each month.
After I ftp the backup to a standby server the vacuum is run.
The database is pretty small it only grows by
Could you please sign them with your PGP key and upload them again? I
think I can upload them to main FTP site.
do i do that with rpm or can i just sign them and provide the signautres in
textfiles next to the rpm files?
---(end of
Zlatko Mati wrote:
Hi. I know that superusers are allowed to do everything on the
database, but I consider this as dangerous. I want to have some user
group with rights of creating new users and giving them some
authorizations, but without such wide power as superusers have. So, I
was thinking
Zlatko Mati wrote:
Hello.
Till now I've been working with Postgres only through pgAdminIII.
Postgres is installed on WIndows XP. Now I need to use pg_dumpall. I
have found folder with different Postgres aplications, placed in
C:\Program Files\PostgreSQL\8.0\bin. When I double-click on any of
Zlatko Mati wrote:
I know that superusers are allowed to do everything on the database,
but I consider this as dangerous. I want to have some user group with
rights of creating new users and giving them some authorizations, but
without such wide power as superusers have. So,
I was thinking
On Wed, 2005-06-15 at 10:55, Richard Huxton wrote:
Zlatko Mati wrote:
Hello.
Till now I've been working with Postgres only through pgAdminIII.
Postgres is installed on WIndows XP. Now I need to use pg_dumpall. I
have found folder with different Postgres aplications, placed in
I was thinking of using cursors as a paging mechanism for an application.
Let's say I need to fetch pagenr from a table.
If I use these commands from the client it works:
BEGIN WORK;
DECLARE my_cursor CURSOR FOR
SELECT * FROM test1 ORDER BY id ASC
FOR READ ONLY;
MOVE pagenr*pagesize IN
Richard Huxton wrote:
Zlatko Mati wrote:
Hello.
Till now I've been working with Postgres only through pgAdminIII.
Postgres is installed on WIndows XP. Now I need to use pg_dumpall. I
have found folder with different Postgres aplications, placed in
C:\Program Files\PostgreSQL\8.0\bin. When I
Richard Huxton dev@archonet.com writes:
Zlatko Matiæ wrote:
I was thinking about two possible scenarios: a) to allow regular users
to create new users b) to restrict superuser's permissions
What is possible and what do you suggest ?
Neither is possible directly. (B) means they're not a
On Tue, Jun 14, 2005 at 07:41:11PM -0400, Bruce Momjian wrote:
Steve - DND wrote:
Simple question I'm sure, but how can I get the transaction ID that a query
is currently running in? I can find all kinds of documentation talking about
transaction ids, but nothing about how to get the
On Wed, 2005-06-15 at 12:50 -0400, Tom Lane wrote:
I might look at
adding that frammish into it
Frammish?
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Hi all,
I have the following in a plpgsql proc on 7.3.4:
code
DECLARE
...
curTime TIMESTAMP;
ppsCnt INT;
BEGIN
...
-- this works
SELECT INTO curTime localtimestamp;
-- get unix seconds from current time (doesn't work)
SELECT INTO ppsCnt EXTRACT (EPOCH FROM TIMESTAMP curTime );
--
hi
can someone send me a link to a graphical client for postgre?
i use suse 9.2 and postgre 8
thx uruz
---(end of broadcast)---
TIP 8: explain analyze is your friend
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 15 Jun 2005, uruz wrote:
can someone send me a link to a graphical client for postgre?
i use suse 9.2 and postgre 8
I'd offer pgadmin3:
http://www.pgadmin.org
Also, Aquafold Data Studio is a powerfult client for PostgreSQL (and
On Wed, 15 Jun 2005, Matthew Phillips wrote:
Hi all,
I have the following in a plpgsql proc on 7.3.4:
code
DECLARE
...
curTime TIMESTAMP;
ppsCnt INT;
BEGIN
...
-- this works
SELECT INTO curTime localtimestamp;
-- get unix seconds from current time (doesn't work)
SELECT INTO
Tom Lane wrote:
Richard Huxton dev@archonet.com writes:
Zlatko Mati wrote:
I was thinking about two possible scenarios: a) to allow regular users
to create new users b) to restrict superuser's permissions
What is possible and what do you suggest ?
Neither is possible directly. (B) means
On Fri, Jun 10, 2005 at 02:24:40PM +0200, Rodríguez Rodríguez, Pere wrote:
I don't know that it happens with my email I will change the email of my
subscription.
The examples are very interesting for my, and Alvaro Herrera's comments too.
In reference to INOUT/OUT params and return a set I
I just took the test. It did for me what I thought it would do, it
made me read the docs from cover to cover (very quickly, and not the
appendices) with a firm deadline. If I hadn't scheduled the test, I
would not have done that. I learned some things.
Here are my comments on the test as an
Stephan,
Thanks, this does work. I assume that the usage of 'TIMESTAMP'
only applies when a literal representation of the date is
given.
Matthew
Stephan Szabo wrote:
On Wed, 15 Jun 2005, Matthew Phillips wrote:
Hi all,
I have the following in a plpgsql proc on 7.3.4:
code
DECLARE
...
On Thu, 2005-06-09 at 21:30 -0400, Edmund Dengler wrote:
We have 2 base tables, and use INHERITS to partition the data. When we get
around 2000-2200 sub-tables (approx 1000-1100 per base table), planning a
SELECT statement on the base table (ie, to search all sub-tables) will
start slowing
On Fri, 2005-06-10 at 02:10 -0400, Tom Lane wrote:
What I see in the profile is
% cumulative self self total
time seconds secondscalls s/call s/call name
42.04 15.5815.58 9214 0.00 0.00 list_nth_cell
20.29 23.10
Hi,
I'm completely new to PostgreSQL. I don't have any idea how to install it on a Suse Linux machine. Could somebody provide me installation instructions ?
Many thanks in advance,
Nico Callewaert
Discover Yahoo!
Have fun online with music videos, cool games, IM & more. Check it out!
On Wed, 2005-06-15 at 16:54, Nico Callewaert wrote:
Hi,
I'm completely new to PostgreSQL. I don't have any idea how to
install it on a Suse Linux machine. Could somebody provide me
installation instructions ?
Many thanks in advance,
Insert your suse installation medium, and run
Nico Callewaert wrote:
Hi,
I'm completely new to PostgreSQL. I don't have any idea how to
install it on a Suse Linux machine. Could somebody provide me
installation instructions ?
SuSE provides Postgresql rpms, simply use YAST to install new software.
--
Until later, Geoffrey
Hi,
Thank you for taking the test and giving comments.
I just took the test. It did for me what I thought it would do, it
made me read the docs from cover to cover (very quickly, and not the
appendices) with a firm deadline. If I hadn't scheduled the test, I
would not have done that. I
This is a simple question what is the best way to execute a SQL script,
this script will create schemas and tables for a database i created.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Simon Riggs [EMAIL PROTECTED] writes:
Looks bad... but how does it look for 1000 inherited relations? My
feeling is that we should not be optimizing the case above 1000
relations. That many partitions is very unwieldy.
Well, it's not so much that I care about queries with 1000+ relations,
as
Well, it's not so much that I care about queries with 1000+ relations,
as that this is a good way to stress-test the code and find out where
the performance issues are. There are many thousand lines of code that
can never be performance-sensitive, but to expose the ones that are
it helps to push
Simon Riggs [EMAIL PROTECTED] writes:
If you really do need that many, you can go to the trouble of grouping
them in two levels of nesting, so you have a root table, multiple month
tables and then each month table with multiple day tables (etc).
I wonder if testing deeply nested inheritance
62 matches
Mail list logo