Due to a lack of time, I'm closing the thread. It takes a little more
code, but I've decided to just forget about the loop and write every
single statement in my function.
Thanks anyway for explaning and brainstorming.
Ragnar [EMAIL PROTECTED] 2006-11-28 10:28
On þri, 2006-11-28 at 09:14 +0100,
Jeff Herrin wrote:
I don't think cursors are going to help in this case. The order by random() is
still going to give different result sets on different pages.
Jeff
A cursor will maintain the order it was created with until it is
disposed of.
It won't work with a web app though as each
Hi list,
I would like to know if it is necessary to set my database to
autovaccum if the intent of my DB Manager is do not make any deletion
in any time.
If there is no deletions why autovaccum ok ?
Regards
Ezequias
---(end of broadcast)---
TIP
Ezequias Rodrigues da Rocha wrote:
Hi list,
I would like to know if it is necessary to set my database to
autovaccum if the intent of my DB Manager is do not make any deletion
in any time.
If there is no deletions why autovaccum ok ?
You need to vacuum from time to time anyway, even if
On 30/11/06, Alvaro Herrera [EMAIL PROTECTED] wrote:
Ezequias Rodrigues da Rocha wrote:
Hi list,
I would like to know if it is necessary to set my database to
autovaccum if the intent of my DB Manager is do not make any deletion
in any time.
If there is no deletions why autovaccum ok ?
It is possible to set this up on PgAdmin ?
I need to shutdown the postgresql service to change this parameters ?
ps: Your information was very clear for me. Thank you very much.
Ezequias
2006/11/30, Peter Childs [EMAIL PROTECTED]:
On 30/11/06, Alvaro Herrera [EMAIL PROTECTED] wrote:
Alvaro Herrera wrote:
Ezequias Rodrigues da Rocha wrote:
Hi list,
I would like to know if it is necessary to set my database to
autovaccum if the intent of my DB Manager is do not make any deletion
in any time.
If there is no deletions why autovaccum ok ?
You need to vacuum from time to
Hey guys, sorry if this is slightly OT for this list, but I figure it's a
simple question. If I'm storing pg_xlog on a second non-redundant drive
using the symlink method and the journal drive were to crash, how difficult
is recovery? Will Postgresql simply be able to reinitialize the journal on
Michael,
I think you may have solved my problem. We're still experimenting with it but I
think setseed is going to work. Thank you very, very much!
Jeff Herrin
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Jeff Herrin [EMAIL PROTECTED]
Cc: Andreas Kretschmer [EMAIL
Travis Whitton [EMAIL PROTECTED] writes:
Hey guys, sorry if this is slightly OT for this list, but I figure it's a
simple question. If I'm storing pg_xlog on a second non-redundant drive
using the symlink method and the journal drive were to crash, how difficult
is recovery? Will Postgresql
Ezequias Rodrigues da Rocha wrote:
It is possible to set this up on PgAdmin ?
I don't know.
I need to shutdown the postgresql service to change this parameters ?
No, you can just modify the params in postgresql.conf and HUP the server
so that it re-reads the config file, no restart
Just a little question.
What is the interval of time the vacuum will run on my database ?
Ezequias
2006/11/30, Matthew T. O'Connor matthew@zeut.net:
Ezequias Rodrigues da Rocha wrote:
It is possible to set this up on PgAdmin ?
I don't know.
I need to shutdown the postgresql service to
Hi list,
It is possible to make a selection like
Select (list 1 to 1000);
And get the rows ?
producao=# select ...;
row
-
1
2
3
.
.
.
1000
--
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Atenciosamente
On 11/30/06, Ezequias Rodrigues da Rocha [EMAIL PROTECTED] wrote:
Hi list,
It is possible to make a selection like
Select (list 1 to 1000);
And get the rows ?
producao=# select ...;
row
-
1
2
3
.
.
.
1000
*select * from generate_series(1, 1000);*
See
Ezequias Rodrigues da Rocha wrote:
Hi list,
It is possible to make a selection like
Select (list 1 to 1000);
Sure, use the generate_series() function.
select * from generate_series(1, 1000);
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL
Uow !
1 to one m
select * from generate_series(1, 100);
In 5203 miliseconds (that's a great performmance). My server is not
quite good but the performance was great for me.
Thank you so much
Ezequias
2006/11/30, Aaron Bono [EMAIL PROTECTED]:
On 11/30/06, Ezequias Rodrigues da Rocha
Hi list,
I am having problem with grants and users on PostgreSQL.
I am using pgAdmin to connect like other user to test my permissions.
As the owner of the database I have criated two roles:
administrators (cannot connect)
ezequias (can connect)
I give permissions to a table I have:
GRANT
You did not grant access privileges to schema.
Also GRANT administrators on the base schema as you did for the table.
--Imad
www.EnterpriseDB.com
On 12/1/06, Ezequias Rodrigues da Rocha [EMAIL PROTECTED] wrote:
Hi list,
I am having problem with grants and users on PostgreSQL.
I am using
am Fri, dem 01.12.2006, um 8:31:41 +0200 mailte Pascal Tufenkji folgendes:
Hi,
Can I retrieve the row number in a select statement?
For example : if I have the following table ?foo?
I should obtain the following result :
row_number | col1 | col2
---+--+-
19 matches
Mail list logo
