Tagged Questions
1
vote
0answers
24 views
Can spatial index help a “range - order by - limit” query
Asking this question, specifically for Postgres, as it has good supoort for R-tree/spatial indexes.
We have the following table with a tree structure (Nested Set model) of words and their ...
2
votes
0answers
114 views
How do I design a database for continents, countries, regions, cities and POIs?
I am not a database designer so I'm having trouble designing database with GIS information. The goal is to create a system with continents, countries, regions (including states, sub-regions, ...
1
vote
1answer
45 views
Impact of changing schema name
I have a server with two databases. Each database has a different schema name despite the fact that DB2 is a subset of DB1 (DB2 has a subset of the tables in DB1).
Not withstanding any code changes ...
1
vote
2answers
64 views
Joining based on date (or date range)
I'm not sure if I've completely fudged the design of my small hobby database (I'm not a DBA by any means), but I have a table like this (primary key is (staffid, effectivefrom)):
staffid | target | ...
3
votes
2answers
159 views
Database for building a realtime analytics system
I want to build a system similar to Google Analytics (only used for internal use, less traffic and less feature), and mainly focus on
Real time counting of unique URI visit/PV by different ...
1
vote
1answer
122 views
Curiosity: Table structure/schema for spreadsheet-like web app (ex: Google Docs)?
I'm a front-end developer/designer who is trying to branch out and learn more about the back-end world. I've chosen Python, Django, and Postgres was my starting place. My goal is to build a personal ...
3
votes
1answer
45 views
Want to add a “variable” to a table
I'm using PostgreSQL 8.4 and I have a table that is cleared out and refilled with new data every so often. I want to be able to store the date that the table was last filled, but I'm not sure where to ...
4
votes
3answers
230 views
PostgreSQL designing tool
I am about to design my first database which is going to run with PostgreSQL. I am used to the magnificant tool called MySQL Workbench. It is useful and it looks good which I kind of expect from a ...
5
votes
1answer
174 views
Concept of Schema in Postgresql
I am not able to understand concept and usage of schema in Postgresql. I have no idea how it can affect my database design.
Why should I use it?
Can it affect me in future if I decide to not think ...
1
vote
2answers
204 views
Database Transfer from PostgreSQL to MySQL
Is there any method to tranfer the data and schema from a postgresql database to mysql?
1
vote
0answers
311 views
Removing Archive Logs after PostgreSQL PITR online-recovery
I'm using pgpool-II + PostgreSQL 8.4 on three servers: primary + standby1 + standby2.
Replication mode is "on"
Load balance mode is "on" (between primary and standby1)
I followed the official ...
3
votes
2answers
188 views
How can I specify the position for a new column in PostgreSQL?
If I have a table with the columns:
id | name | created_date
and would like to add a column, I use:
alter table my_table add column email varchar(255)
Then the column is added after the ...
5
votes
4answers
819 views
Finding empty columns of a table in PostgreSQL
What query would return the name of the columns of a table where all rows are NULL?
4
votes
2answers
289 views
Where does the magic column “name” come from?
I got this by accident:
db=> select name from site;
ERROR: column "name" does not exist
LINE 1: select name from site;
^
db=> select site.name from site;
name
...
0
votes
1answer
163 views
How to design databases? [closed]
Describe the process in steps, please. What tools do you use for it?
