Re: [GENERAL] Index only select count(*)

> > > On Oct 7, 2013, at 11:34, Toni Helenius > > > > > > wrote: > > > > > > > Hi, > > > > > > > > yes, I'm cheating by using GUI :) (PgAdmin) > > > > > > Please do not top-post. > > > > >

Re: [GENERAL] Index only select count(*)

> > On Oct 7, 2013, at 11:34, Toni Helenius > > > > wrote: > > > > > Hi, > > > > > > yes, I'm cheating by using GUI :) (PgAdmin) > > > > Please do not top-post. > > > > Analyze is an entirely different command tha

Re: [GENERAL] Index only select count(*)

> On Oct 7, 2013, at 11:34, Toni Helenius > wrote: > > > Hi, > > > > yes, I'm cheating by using GUI :) (PgAdmin) > > Please do not top-post. > > Analyze is an entirely different command than Explain analyze. Analyze > updates the statistics o

Re: [GENERAL] Index only select count(*)

oops=1)" "Total runtime: 2912.211 ms" -Original Message- From: Alban Hertroys [mailto:haram...@gmail.com] Sent: 7. lokakuuta 2013 12:31 To: Toni Helenius Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Index only select count(*) On Oct 7, 2013, at 11:23, Toni Hel

[GENERAL] Index only select count(*)

nd all. No help. The output of analyze: "Aggregate (cost=18240.50..18240.51 rows=1 width=0)" " -> Seq Scan on min1_009 (cost=0.00..18108.60 rows=52760 width=0)" -- Toni Helenius

[GENERAL] Convierte y exporta PostgreSQL a MySQL (FREE)

PostgreSQL a MySQL HL-DBExporter (PostgreSQL a MySQL) www.hlevelsoft.com/index.php/es/postgres/postgresql-mysqlb  La aplicación HL-DBExporter (PostgresSQL a MySQL) permite exportar,convertir,transferir, migrar datos de una base de datos PostgreSQL a otra base de datos MySQL.  Puede trabaja

[GENERAL] Pg_dump version mismatch

Hello, I'm a newbie in this list. I'm working with a Debian 4.0 linux server, and I've installed postgresql 8.2.6. I didn't update to 8.2.7 When I try to do a pg_dump to backup my databases, It shows this error: pg_dump: server version: 8.2.7; pg_dump version: 8.2.6 pg_dump: aborting b

[GENERAL] Pg_dump version mismatch

Hello, I'm a newbie in this list. I'm working with a Debian 4.0 linux server, and I've installed postgresql 8.2.6. I didn't update to 8.2.7 When I try to do a pg_dump to backup my databases, It shows this error: pg_dump: server version: 8.2.7; pg_dump version: 8.2.6 pg_dump: aborting because

[GENERAL] Pg_dump version mismatch

Hello, I'm a newbie in this list. I'm working with a Debian 4.0 linux server, and I've installed postgresql 8.2.6. I didn't update to 8.2.7 When I try to do a pg_dump to backup my databases, It shows this error: pg_dump: server version: 8.2.7; pg_dump version: 8.2.6 pg_dump: aborting b

[GENERAL] generic crosstab

I'm using the PostgreSQL crosstab functions to do something like this: From this table ... ax 10 bx 13 ay 11 by 17 ... I get: xy a10 11 b13 17 To get the second table I have to specify the field list when I call t

[GENERAL] copy row tree

I have a set of tables with one-to-many relationships between them: T1 <-->> T2 <-->> T3 <-->> T4 I need to copy some rows of these tables to another set of tables which have the same fields. There are two rows on T1 that I want to copy, and then those rows of T2 linked to the other ones, and

[GENERAL] sync linux and postgresql users and groups

Is this possible? It want to avoid the need for two passwords, one for login and another one for the database. The user accounts and the Postgresql server are on the same machine. _ Moda para esta temporada. Ponte al día de todas

[GENERAL] dependencies between objects

I have got some views (for example view B) that use another views (for example view A) in the FROM clause. If I want to change view A, and it doesn't allow me to (for example adding a new column), another way would be dropping A and recreating it with the new column, but it doesn't allow me to

[GENERAL] accessing text of the query in a rule

I am making rules for a table and I want to know what values or variables can I use apart from the "new..." and old... fields, for example I would like to read the SQL query that the user wrote that caused this rule to execute. Can this be done? ---(end of broadcast)-

Re: [GENERAL] How many fields in a table are too many

But if you have significantly more than this number, you should have a good reason, than it's ok as well. What I think is more important, is that you have a tight look on the nature of your data. Treat a number like a number and a date like a date. Ciao, Toni MT wrote: Hi, Just a quick question,

[GENERAL] consistency check ?

Hi to all, I am considering to use PostgreSQL. But I need some more information about some features: Is there a consistency check? Online or Offline? Thanks Toni