181 reputation
18
bio website
location
age
visits member for 2 years, 1 month
seen Oct 28 at 7:40

Sep
3
comment is this dead simple query too slow?
you can run an EXPLAIN and EXPLAIN ANALYSE for query SELECT firstName FROM USER ask something more specific. If you don't understand the output then post it here.
Aug
19
awarded  Teacher
Jul
14
awarded  Notable Question
Jul
9
comment Creating a table for indexing another table
you should update the question with table structure, sample query and sample results. there are many guys around here who might be able to help but doesn't bother because of lack of information.
Jul
3
answered Does having a big table that I do not query cause the whole DB to be slower?
Jun
20
awarded  Citizen Patrol
Feb
5
comment Hierarchical structure with limited number of records per user
Thanks, I think in my case having a check like CHECK(ID > ParentID) would do just fine. Because I can't foresee any special condition whe inverse could be the case.
Feb
5
comment Hierarchical structure with limited number of records per user
also, when you say 'your design does not prevent cycles' can you suggest any better way to approach this ? I'd prefer a better design.
Feb
5
comment Hierarchical structure with limited number of records per user
I see. This is getting closer. please elaborate on your design does not prevent cycles. We can easily enforce that via constraints as well. thanks
Feb
5
comment Hierarchical structure with limited number of records per user
@CraigRinger Yes I've already looked into ltree module but I think I overlooked some of its functionality or I dont completely understand how I can use it in conjugation with other records in database. and of course I need to think about locking, thanks for confirming that I was not over concerned about it. Can you help with some ltree implementations ?
Feb
5
asked Hierarchical structure with limited number of records per user
Sep
5
awarded  Popular Question
Mar
12
reviewed Approve Performing SELECT on EACH ROW in CTE or Nested QUERY?
Mar
12
asked Performing SELECT on EACH ROW in CTE or Nested QUERY?
Feb
20
awarded  Commentator
Feb
20
comment Storing logs on per day basis in PostgreSQL
@dezso, Could you please post your ideas as an answer ? I'm desperately looking for a proper way to do this.
Feb
19
comment Storing logs on per day basis in PostgreSQL
@dezso we dont actually sells anything, It was an example scenario that just happens to match with ours. anyway, there can be a couple thousand insertions in a day if I talk about the real problem. same can be said for reading records, a couple thousand Select per day.
Feb
18
revised Storing logs on per day basis in PostgreSQL
Added results from main edit
Feb
18
awarded  Editor
Feb
18
comment Storing logs on per day basis in PostgreSQL
@dezso I just have update the question if you want to take a look