The postgresql-9.0 tag has no wiki summary.
0
votes
1answer
112 views
PostgreSQL Error : server closed the connection unexpectedly
I cannot connect to PostgreSQL server from PgAdmin III , so i get this error:
Error connecting to the server: server closed the connection
unexpectedly
This probably means the server ...
0
votes
3answers
130 views
Vacuum settings for mostly append-only data
I have a table with the following characteristics:
We INSERT a few 100k rows each day
We never UPDATE the rows
We DELETE "old" data once a week
From my shallow knowledge of Postgres VACUUM, it ...
1
vote
1answer
183 views
Postgresql querying trends
Firstly apologies if this is a duplicate, I am fairly new to SQL and so Im not sure what the correct terminology to use in my searches
So I have a database which records motor races, with the ...
4
votes
2answers
253 views
Select longest continuous sequence
I am trying to construct a query in PostgreSQL 9.0 that gets the longest sequence of continuous rows for a specifc field.
Consider the following table:
lap_id (Serial), lap_no (int), car_type ...
5
votes
1answer
480 views
How can I correctly choose maximum number of occurrences of a string while grouping by another field?
I am using Postgresql 9.0. I have the following fields in a table: id, name.
id name
1 John
1 Mary
1 Mary
1 Mary
1 John
1 Mary
3 Paul
3 Paul
3 George
...
