[PERFORM] More speed counting rows
Hello, I am trying to optimize the count of files when I am using filters (select by some row/s parameter/s) In this case I think that postgresql really count all files. Resulting in unacceptable times of 4 seconds in http server response. Triggers+store in this case do not see very acceptable, because I need store 1.5 millions of counting possibilities. My question is: Any method for indirect count like ordered indexes + quadratic count? Any module? Any suggestion? -- -- -- Publicidad y Servicios http://www.pas-world.com Directorio http://www.precioventa.com Tienda http://informatica.precioventa.com/es/ Autoridad certificadora http://ca.precioventa.com/es/ -- -- -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
Re: [PERFORM] More speed counting rows
> How "up to date" do the counts need to be? If the count takes 4 > seconds, can you run it every minute and store the counts in a table for > retrieval by the HTTP requests? Now, I am storing integer value for filter in memory with timeout, but in busy server, system sure crash without system memory (>700MB for all combinations, if combinations counted > deleted memory count by timeout). > Or does it absolutely have to be the > exact count at the moment of the request? Some applications could fail, without exact number. -- -- -- Publicidad y Servicios http://www.pas-world.com Directorio http://www.precioventa.com Tienda http://informatica.precioventa.com/es/ Autoridad certificadora http://ca.precioventa.com/es/ -- -- -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
[PERFORM] Best VPS provider for running performant PostgreSQL database server
I wasn't sure whether to post this in general, admin or performance but since it is basically a performance question I went with performance. I'm about to launch a new a website that is written using the Django web framework and has PostgreSQL as the database server. Unfortunately I can't afford to get dedicated hardware at the launch of the website as I won't be making money off it for a couple of months (maybe longer). So I was wondering if anyone had any recommendations for decent VPS providers that have good hardware specs for running a PostgreSQL server? I'll be using PostgreSQL 9.4. The database is likely to be quite small (under 1GB) for quite sometime so should I go for double the size of the database in RAM so I can fit it all in memory if required? The database will be mainly read only with only a small number of writes (although as new features are added the number of database write operations will increase). I guess SSDs are essential these days but am I right about the amount of RAM? Is there anything else I should be looking out for? I'll just be running PostgreSQL on the VPS, the web server and app server will be run on different VPSs. In the past I've used Linode, Digital Ocean, Vultr and RamNode. I've become disheartened by Digital Ocean so don't want to use them for this project. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
