Re: [SQL] Long SQL Update Question
You can turn on logging ... but your transaction would be even slower after that. The following links should give you some pointers: http://www.postgresql.org/docs/8.1/static/monitoring-stats.html http://www.postgresql.org/docs/8.1/static/monitoring.html Also try Nagios monitoring plugins for PostgreSQL. Get it from pgFoundry. --Imad www.EnterpriseDB.com On 11/4/06, Dylan Lorimer <[EMAIL PROTECTED]> wrote: So I kicked off a SQL transaction that has been running for 30+ minutes. Is there any way to monitor it to know if it has possibly hanged or not? To be fair, it is an update on 4+ million rows, so I expect it to run for a bit. But any stats or metrics I can get would be helpful. Cheers, dylan ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[SQL] Create View
I don't know whether this is a simple one that has been dealt with before, but if so, I haven't worked out the right question to search on. If I create a view thus: create view things as select * from whatever; and then examine my saved view, I find a list of all of the fields from whatever. I thought it should be possible to save the star (*) as part of the view. Otherwise, I run into the problem of not getting all of the fields if I add columns to the table (whatever). Is this an SQL thing or a PostGreSQL thing? Thanks, Mark -- Mark Simon Manngo Net Pty Ltd Phone/Fax: 1300 726 000 mobile: 0411 246 672 email: [EMAIL PROTECTED] web: http://www.manngo.net Resume: http://mark.manngo.net
[SQL] Create Function (SQL)
I am trying to create a simple function using SQL rather than PGSQL. At this point, it's just for the exercise. Is it possible to create a function similar to the following: create function thing(text) as select * from whatever where id=$1; Do I need to specify all of the columns from the table (whatever) as out parameters, or as a return type, or can I have a generic table returned from this? Thanks, Mark -- Mark Simon Manngo Net Pty Ltd Phone/Fax: 1300 726 000 mobile: 0411 246 672 email: [EMAIL PROTECTED] web: http://www.manngo.net Resume: http://mark.manngo.net
Re: [SQL] Create View
Mark Simon wrote: > create view things as select * from whatever; > > and then examine my saved view, I find a list of all of the fields > from whatever. I thought it should be possible to save the star (*) > as part of the view. Otherwise, I run into the problem of not getting > all of the fields if I add columns to the table (whatever). > > Is this an SQL thing or a PostGreSQL thing? SQL -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
