[GENERAL] Large database
I would like to ask the more experienced users on Postgres database a couple of questions I have on a db I manage with a lot of data. A lot of data means something like 15.000.000 rows in a table. I will try to describe the tables and what I will have to do on them :) There is a table that has product data in the form of Table product: product_id varchar(8), product_name text and product actions table: product_id varchar(8), flow char(1), who int, where int, value float. I will have to make sql queries in the form "select value from product_actions where who='someone' and where='somewhere' and maybe make also some calculations on these results. I allready have made some indexes on these tables and a view that joins the two of them but I would like to ask you people if someone is using such a big db and how can I speed up things as much as it is possible on this ... these product_actions tables exists for each year from 1988 till 2003 so this means a lot of data... Thanks in Advance ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Unicode problem ???
I am also using postgres database with delphi. Therefor I don't use ODBC but I use the Zeos Database components for delphi. I had similar problems though. My database is in iso8859-7 and I needed Greek chars to appear corectly in my application. What I did is I am running an sql statement when my application is starting up (after my datasource connection to the db etc) and I am setting my client's encoding to iso8859-7. No problems since then ... Greeks show ok .. they are stored ok and the search on the data works file. Hope I helped a little Alexander Antonakakis John Sidney-Woollett wrote: Priem, Alexander said: Could this be due to the fact that the database was CREATED using SQL_ASCII encoding? Maybe your solution only works when the database was created using LATIN1 or UNICODE encoding. Yes, I suspect Maybe I'll just try recreating the database using UNICODE or LATIN1 encoding tomorrow. UNICODE seems the best, right? Or does LATIN1 have more possibilities than UNICODE? Unicode has a larger character set than latin-1. But if you only need to support latin-1 then use that... Of course, if you have to upgrade to support unicode later, you'll wish you had started off using latin-1! I'm no expert on this, so I hope this info is correct. John Sidney-Woollett ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[GENERAL] ip of the user doing an insert
Is there a function or other way to get the user's ip address the moment an insert is performed? Supposed that many people with the same "pg_username" are conected to the database so no username tracking is usefull. Thanks in advance Alexander Antonakakis ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
