Install new language - Prev: Re: [GENERAL] Are you frustrated with PostgreSQL
Folks: I would like to thank for those who answer my questions. My client have decide to switch from MySQL to PostgreSQL. I have successfully installed PostgreSQL with Cygwin on my XP laptop. It's a good start. I, however, have some other questions. 1. I am viewing the database from both PostgreSQL manager and PgAdmin III. I can see there are three languages (C, Internal, SQL) in PostgreSQL, but not in PgAdmin III. I login with the same user. Any idea? 2. Do I have to install new language pl/pgSQL in order to write functions? 3. When I start PostgreSQL, I found there are at least 4 instance of postgres.exe running as NT services when there is not connection. Each single one use different amount of memory. Is that normal? 4. The stored procedure term confused me. I did not see any create procedure statement in the document. I used a lot of procedures/packages in Oracle and MS-SQL. Are there such things in PostgreSQL? How do I do that in PostgreSQL? Just use Function? I could not find examples on how to call a function like Exec MyFunctionName(..). 5. I start PostgreSQL with the comman pg_ctl start -D /var/pgsql/data I got the following message: It says the database was not shut down properly? What I did wrong? I shut down the database with this command pg_ctl stop -D /var/pgsql/data -m immediate when no connection exist. $ LOG: database system was interrupted at 2003-07-15 23:59:00 USMST LOG: checkpoint record is at 0/8C17D0 LOG: redo record is at 0/8C17D0; undo record is at 0/0; shutdown FALSE LOG: next transaction id: 4428; next oid: 25168 LOG: database system was not properly shut down; automatic recovery in progress LOG: ReadRecord: record with zero length at 0/8C1810 LOG: redo is not required LOG: database system is ready 6. What kind of hardware configuration would you experts recommend for application runnng on one stand along machine. -- Critical but not 24x7 -- RedHat 8, 9? -- PHP 4 -- Apache 2 -- PostgreSQL 7.3.3 -- ODBC -- up to 1500 pages hit and 1000 database hit (select/update/insert) per minute. -- Expect up to 1GB data in the first year -- Expect to spend up to US $2000 for hardware (not include monitor) 7. Is there any experienced PostgreSQL DBA in Phoenix, Arizona USA? Please contact me offline. My client would love to get some help from you on administration/backup/restore stuff as an extra resource. Can you image that I got my PostgreSQL setup and running in few hours. Cool! Thanks! This mailling list is great! You people are great! Terence Chang ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: Install new language - Prev: Re: [GENERAL] Are you frustrated with PostgreSQL
For some of your Cygwin specific questions you may want to look at the ports mailing list. They will be more knowledgeable there. I would like to thank for those who answer my questions. My client have decide to switch from MySQL to PostgreSQL. I have successfully installed PostgreSQL with Cygwin on my XP laptop. It's a good start. I, however, have some other questions. 1. I am viewing the database from both PostgreSQL manager and PgAdmin III. I can see there are three languages (C, Internal, SQL) in PostgreSQL, but not in PgAdmin III. I login with the same user. Any idea? I don't use PgAdmin so I can't answer your question. 2. Do I have to install new language pl/pgSQL in order to write functions? If you are wanting to write them in PL/pgSQL yes. There are several command-line tools that allow you to do this without getting into the database itself. You should read the Administrator's Guide PDF document that can be found ... Note - if you install any language in template1 all databases that you create based on template1 from then on out will have those languages installed by default. If you are like me and create databases based on template0 you don't get the results you desired... 3. When I start PostgreSQL, I found there are at least 4 instance of postgres.exe running as NT services when there is not connection. Each single one use different amount of memory. Is that normal? I haven't used the Cygwin version in a long time but given that there are multiple pgsql instances running on my Linux box without connections I would assume that this is the normal mode of operation under Cygwin as well. 4. The stored procedure term confused me. I did not see any create procedure statement in the document. I used a lot of procedures/packages in Oracle and MS-SQL. Are there such things in PostgreSQL? How do I do that in PostgreSQL? Just use Function? Just use function. Same basic mode of operation but different name. I could not find examples on how to call a function like Exec MyFunctionName(..). You treat functions as you would 5. I start PostgreSQL with the comman pg_ctl start -D /var/pgsql/data I got the following message: It says the database was not shut down properly? What I did wrong? I shut down the database with this command pg_ctl stop -D /var/pgsql/data -m immediate when no connection exist. $LOG: database system was interrupted at 2003-07-15 23:59:00 USMST LOG: checkpoint record is at 0/8C17D0 LOG: redo record is at 0/8C17D0; undo record is at 0/0; shutdown FALSE LOG: next transaction id: 4428; next oid: 25168 LOG: database system was not properly shut down; automatic recovery in progress LOG: ReadRecord: record with zero length at 0/8C1810 LOG: redo is not required LOG: database system is ready Are you still running under Cygwin? Does that work under Cygwin or do you need to use the services control panel to start/stop? If you try to start PostgreSQL and there is a .pid in the data directory then it will tell you that the system was not properly shut down. 6. What kind of hardware configuration would you experts recommend for application runnng on one stand along machine. -- Critical but not 24x7 -- RedHat 8, 9? -- PHP 4 -- Apache 2 -- PostgreSQL 7.3.3 -- ODBC -- up to 1500 pages hit and 1000 database hit select/update/insert) per minute. -- Expect up to 1GB data in the first year -- Expect to spend up to US $2000 for hardware (not include monitor) Hit eBay and you can get a decent dual-Xeon with a gig of RAM and some nice SCSI drives w/ a RAID card. Can you image that I got my PostgreSQL setup and running in few hours. Cool! Having software that just works is always nice. Certainly makes my life easier. rjsjr ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: Install new language - Prev: Re: [GENERAL] Are you frustrated with PostgreSQL
I'm going to skip the questions that I don't know the answer. - Original Message - From: Terence Chang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 9:05 PM Subject: Install new language - Prev: Re: [GENERAL] Are you frustrated with PostgreSQL Folks: I would like to thank for those who answer my questions. My client have decide to switch from MySQL to PostgreSQL. I have successfully installed PostgreSQL with Cygwin on my XP laptop. It's a good start. I, however,have some other questions. 1. I am viewing the database from both PostgreSQL manager and PgAdmin III. can see there are three languages (C, Internal, SQL) in PostgreSQL, but not in PgAdmin III. I login with the same user. Any idea? PgAdmin shows only procedural languages. If You execute: SELECT * from pg_language; You'll se the column lanispl and PgAdmin shows only those languages where lanisp is TRUE. 2. Do I have to install new language pl/pgSQL in order to write functions? Yes. Do something like this: CREATE OR REPLACE FUNCTION plpgsql_call_handler() RETURNS LANGUAGE_HANDLER AS '$_LIBPATH/plpgsql.dll', 'plpgsql_call_handler' LANGUAGE 'c'; CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'; where $_LIBPATH is /lib/postgresql by default (on cygwin) 3. When I start PostgreSQL, I found there are at least 4 instance of postgres.exe running as NT services when there is not connection. Each single one use different amount of memory. Is that normal? Yes, 3. 4. The stored procedure term confused me. I did not see any create procedure statement in the document. I used a lot of procedures/packages in Oracle and MS-SQL. Are there such things in PostgreSQL? How do I do that in PostgreSQL? Just use Function? Diferent name for same thing. I like to call triggers as stored procedures because they are not returning data to the user, but difference is only how You declare the function. If You do something like: CREATE OR REPLACE FUNCTION foo() RETURNS TRIGGER AS ' it is a trigger function, and if You do : CREATE OR REPLACE FUNCTION foo() RETURNS int8 AS ' it is function that returns data. Packages are not supported under PostgreSQL. I could not find examples on how to call a function like Exec MyFunctionName(..). SELECT something FROM myFunction(param1,param2) if function returns composite type or SELECT myFunction(param1,param2) if function returns single value. Of course function can return SETOF(array) of simple or SETOF composite type. 5. I start PostgreSQL with the comman pg_ctl start -D /var/pgsql/data I got the following message: It says the database was not shut down properly? What I did wrong? I shut down the database with this command pg_ctl stop -D /var/pgsql/data -m immediate when no connection exist. Under cygwin, You should start and stop postmaster with NET START postmaster and NET STOP postmaster if it is running as service. I it fail to start, in 99% cases responsible is undeleted postmaster.pid file. It is an old Cygwin problem. Go to /usr/share/data and delete postmaster.pid file. You must log-on as postgres. $ LOG: database system was interrupted at 2003-07-15 23:59:00 USMST LOG: checkpoint record is at 0/8C17D0 LOG: redo record is at 0/8C17D0; undo record is at 0/0; shutdown FALSE LOG: next transaction id: 4428; next oid: 25168 LOG: database system was not properly shut down; automatic recovery in progress LOG: ReadRecord: record with zero length at 0/8C1810 LOG: redo is not required LOG: database system is ready What causes this ? Simple query, function or something else ? Can You be more specific. Can you image that I got my PostgreSQL setup and running in few hours. Cool! And it is even better under linux ! I must confess, it took me more. If You have trouble with searching through PostgreSQL documentation, I have compiled searchable CHM file for 7.3.2. Feel free to request it, but be prepared on 1.5 MB in Your mailbox. Regards ! ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] Are you frustrated with PostgreSQL
On Monday 14 Jul 2003 11:16 pm, Terence Chang wrote: Hi all: I am new to PostgreSQL DB, however I have years experience with Oracle 8i and MS SQL. I am in the process to promot PostgreSQL to my future client, due to the cost. I am just wondering if overall people feels frustrated with PostgreSQL or feels happey with it. Pretty happy - easier to admin remotely the MS-SQL. I know MySQL is simpiler and cheap. With my years experience with enterprise level DB like Oracle and MS SQL, I just don't feel right with MySQL. I love stored procedure. Sorry to MySQL lovers. I have the following questions. Please reply me offline, so the mailling list won't get flood. Thanks! 1. What is your favorite GUI tool for PostgreSQL? Mostly use psql, otherwise phpPgAdmin or PgAdmin if I'm on a windows box - I've recently recommended PgAdmin to a client I'm working with and after a couple of hours use he seems to like it. 2. In your organization, do you have someone who works as full time PostgreSQL DBA? Small devt/support shop, so it's me, and I'm not full time for any particular client. 3. What is the biggest challenge you have with PostgreSQL? Administration or Programming? Hmm - error messages in plpgsql - not always as informative as they might be. So that would be Programming. 4. Overall, do you like PostgreSQL? Would you recommend it over MySQL? Yes, very pleased, and yes, I'd recommend it over MySQL. I use both, but I've come to the conclusion that for the sort of custom systems I tend to build / support it makes sense to use a more sophisticated package and perhaps spend a few hundred pounds on hardware if it really matters. 5. How often do your PostgreSQL run into problem or crash? Are most of the problem caused by PostgreSQL itself? Never seen a crash on my systems (well, not one that was caused by PG). I'd not say I've never read about a crash on the mailing lists in the few years I've been here, but most of them seemed to be hardware related in the end. -- Richard Huxton ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] Are you frustrated with PostgreSQL
On 14 Jul 2003 at 15:16, Terence Chang wrote: due to the cost. I am just wondering if overall people feels frustrated with PostgreSQL or feels happey with it. Happy; and you can't beat the cost! 1. What is your favorite GUI tool for PostgreSQL? PgAdmin, though I use psql directly on the Postgres machine a lot too. 2. In your organization, do you have someone who works as full time PostgreSQL DBA? No - just me, and I work part-time both as developer and DBA. 3. What is the biggest challenge you have with PostgreSQL? Administration or Programming? Programming; our applications are fairly low-traffic, so the Postrgres box just sits there and runs itself most of the time. 4. Overall, do you like PostgreSQL? Would you recommend it over MySQL? I've no experience of MySQL, but I like Postgres a lot - I learnt all my DBMS stuff on Postgres, and found it a good learning tool as well as a solid DB backend. 5. How often do your PostgreSQL run into problem or crash? Are most of the problem caused by PostgreSQL itself? It has never crashed, in over four years - all problems I ran into were caused by myself. --Ray. - Raymond O'Donnell http://www.galwaycathedral.org/recitals [EMAIL PROTECTED] Galway Cathedral Recitals - ---(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
Re: [GENERAL] Are you frustrated with PostgreSQL
On 14 Jul 2003 at 15:16, Terence Chang wrote: 1. What is your favorite GUI tool for PostgreSQL? pgaccess - Mac OS X and Linux (will also run on any Tcl capable OS) 2. In your organization, do you have someone who works as full time PostgreSQL DBA? No I look after several database servers online and intranet 3. What is the biggest challenge you have with PostgreSQL? Administration or Programming? Programming - I am self taught so pl/pgsql is a bit of a challenge for me 4. Overall, do you like PostgreSQL? Would you recommend it over MySQL? Yes. Yes. 5. How often do your PostgreSQL run into problem or crash? Are most of the problem caused by PostgreSQL itself? I had a hardware failure and thanks to the list was able to get all my data back from a 6.x generation database. Tony Grant -- www.tgds.net Library management software toolkit, redhat linux on Sony Vaio C1XD, Dreamweaver MX with Tomcat and PostgreSQL ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Are you frustrated with PostgreSQL
On 14/07/2003 23:16 Terence Chang wrote: [snip] I have the following questions. Please reply me offline, so the mailling list won't get flood. Thanks! 1. What is your favorite GUI tool for PostgreSQL? Most of th time, I find psql to be perfectly adequate for the job. If I need to look at long and/or wide result sets I'll use pgaccess. 2. In your organization, do you have someone who works as full time PostgreSQL DBA? Me organised? Being an independent software developer, I tend to wear all the hats. 3. What is the biggest challenge you have with PostgreSQL? Administration or Programming? All fairly straight forward IME. 4. Overall, do you like PostgreSQL? Would you recommend it over MySQL? 100% of the time. 5. How often do your PostgreSQL run into problem or crash? Are most of the problem caused by PostgreSQL itself? I've never had a problem -- Paul Thomas +--+-+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +--+-+ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] Are you frustrated with PostgreSQL
On Tue, 15 Jul 2003 13:23:30 +0100 Paul Thomas [EMAIL PROTECTED] wrote: On 14/07/2003 23:16 Terence Chang wrote: [snip] I have the following questions. Please reply me offline, so the mailling list won't get flood. Thanks! 1. What is your favorite GUI tool for PostgreSQL? Most of th time, I find psql to be perfectly adequate for the job. If I need to look at long and/or wide result sets I'll use pgaccess. psql mostly. i've played with dbvisualizer, found it useful, then found that for one particular combination of versions (postgresql dbvis) it wouldn't show me all tables. i have used Access/ODBC occasionally, but i try no to use M$ products where i can avoid it. pgmanager looks promising, but i've only been playing with it for a day or two. 2. In your organization, do you have someone who works as full time PostgreSQL DBA? Me organised? Being an independent software developer, I tend to wear all the hats. ditto. 3. What is the biggest challenge you have with PostgreSQL? Administration or Programming? All fairly straight forward IME. i'd have to say learning the performance stuff. i have just started reading the performance list and have found it most instructive. i've learned a lot there in a few short days that isn't in any of the PostgreSQL books that i have. i would think that a really hardcore PostgreSQL DBA book along the lines of Loney's Oracle DBA handbooks would be most useful. 4. Overall, do you like PostgreSQL? Would you recommend it over MySQL? 100% of the time. agreed. MySQL is satisfactory for a narrow set of uses, but has some significant limitations. and what with the LGPL-GPL licensing change for MySQL 4.1.x, i am tending to recommend that my clients running MySQL consider their transistion strategies to some other product. 5. How often do your PostgreSQL run into problem or crash? Are most of the problem caused by PostgreSQL itself? I've never had a problem none here, either. it just works. richard -- Richard Welty [EMAIL PROTECTED] Averill Park Networking 518-573-7592 Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] Are you frustrated with PostgreSQL
On Tue, 15 Jul 2003 08:42:27 -0400 (EDT) Richard Welty [EMAIL PROTECTED] wrote: i've played with dbvisualizer, found it useful, then found that for one particular combination of versions (postgresql dbvis) it wouldn't show me all tables. ok, that didn't really come out right. there was a version of dbvisualizer which couldn't see all the tables in a particular version of postgresql. i have since upgraded postgresql to 7.3.3 everywhere but haven't tried dbvisualizer since (i'm developing on a different system now and haven't installed dbvisisualizer on it, as psql has been more than adequate.) richard -- Richard Welty [EMAIL PROTECTED] Averill Park Networking 518-573-7592 Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] Are you frustrated with PostgreSQL
1. What is your favorite GUI tool for PostgreSQL? Tool to do what? As a DBA I find GUI front ends tend to be either too restrictive or try to do too much and thus become too complicated. (Oracle's Enterprise Manager Console is a classic example of feature creep, or is that feature gallop?) OTOH, I'm in the process of writing a GPL table-driven web-based table browser/data entry program in PHP because I can't find one that does what I want. I hope to be able to put out a beta of it by September, assuming my own personal feature gallop is coming down the home stretch by then. :-) -- Mike Nolan ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Are you frustrated with PostgreSQL
OTOH, I'm in the process of writing a GPL table-driven web-based table browser/data entry program in PHP because I can't find one that does what I want. I hope to be able to put out a beta of it by September, assuming my own personal feature gallop is coming down the home stretch by then. :-) In what ways is the application you are writing going to be different from phpPgAdmin? Chris ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] Are you frustrated with PostgreSQL
In what ways is the application you are writing going to be different from phpPgAdmin? I see it as more of a web-based application forms development engine than as a DBA tool. -- Mike Nolan ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] Are you frustrated with PostgreSQL
On 14 Jul 2003 at 15:16, Terence Chang wrote: Hi all: I am new to PostgreSQL DB, however I have years experience with Oracle 8i and MS SQL. I am in the process to promot PostgreSQL to my future client, due to the cost. I am just wondering if overall people feels frustrated with PostgreSQL or feels happey with it. I've been working with databases for about 15 years, including Sybase, Oracle, PostgreSQL, and MySQL. Yes, I'm happy with PostgreSQL. No frustration at all. I know MySQL is simpiler and cheap. With my years experience with enterprise level DB like Oracle and MS SQL, I just don't feel right with MySQL. I love stored procedure. Sorry to MySQL lovers. Stored procedures is one reason I moved http://www.FreshPorts.org/ from MySQL to PostgreSQL. I have the following questions. Please reply me offline, so the mailling list won't get flood. Thanks! If we reply to the list, everyone who asks the same questions as you will be able to find them in the archives. 1. What is your favorite GUI tool for PostgreSQL? I usually use command line tools for PG work, but do use PGAdmin from time to time. 2. In your organization, do you have someone who works as full time PostgreSQL DBA? Yes. 3. What is the biggest challenge you have with PostgreSQL? Administration or Programming?' Finding more time to spend working with it. 4. Overall, do you like PostgreSQL? Would you recommend it over MySQL? Yes. Yes. Friends don't let friends use MySQL. 5. How often do your PostgreSQL run into problem or crash? Are most of the problem caused by PostgreSQL itself? I have never seen a PostgreSQL crash. Most if not all of the problems have been caused by myself. -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] Are you frustrated with PostgreSQL
--- Terence Chang [EMAIL PROTECTED] wrote: I have the following questions. Please reply me offline, so the mailling list won't get flood. Thanks! But if they don't read it, they can't correct me! ;-) 1. What is your favorite GUI tool for PostgreSQL? I create apps using MS Access as the GUI front-end. For administration, I use scripts and the command line. 2. In your organization, do you have someone who works as full time PostgreSQL DBA? No. We wear a lot of hats around here. 3. What is the biggest challenge you have with PostgreSQL? Administration or Programming? Programming -- if I were a Programmer or a DBA, I could do more. A solid database, a solid operating system and a little scripting make day-to-day administration easy enough. 4. Overall, do you like PostgreSQL? Would you recommend it over MySQL? Yes, and yes. MySQL has a reputation for ease of administration; however, I moved from MySQL to PostgreSQL because missing features in MySQL meant difficult work-arounds for users. Also, the \help system in psql is very useful for people learning SQL. As an end-user, I found PostgreSQL easier to use than MySQL. 5. How often do your PostgreSQL run into problem or crash? Are most of the problem caused by PostgreSQL itself? At work, I haven't had any unplanned down time since I started using PostgreSQL over 3 years ago. At home, I had a hard drive crash; but the databases were restored from backup files without any problems. Dependable backups should _not_ be taken for granted! Best regards, Andrew Gould ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] Are you frustrated with PostgreSQL
On Mon, 2003-07-14 at 17:44, Dan Langille wrote: On 14 Jul 2003 at 15:16, Terence Chang wrote: Hi all: [snip] Stored procedures is one reason I moved http://www.FreshPorts.org/ from MySQL to PostgreSQL. Oh, the shame! Advertising AOL For Broadband on a FreeBSD ports site? -- +---+ | Ron Johnson, Jr. Home: [EMAIL PROTECTED] | | Jefferson, LA USA http://members.cox.net/ron.l.johnson | | | | 4 degrees from Vladimir Putin +---+ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Are you frustrated with PostgreSQL
I have been working with various databases since the 80's. Terence Chang wrote: Hi all: I am new to PostgreSQL DB, however I have years experience with Oracle 8i and MS SQL. I am in the process to promot PostgreSQL to my future client, due to the cost. I am just wondering if overall people feels frustrated with PostgreSQL or feels happey with it. I know MySQL is simpiler and cheap. With my years experience with enterprise level DB like Oracle and MS SQL, I just don't feel right with MySQL. I love stored procedure. Sorry to MySQL lovers. I have the following questions. Please reply me offline, so the mailling list won't get flood. Thanks! 1. What is your favorite GUI tool for PostgreSQL? I use PGAdmin for a quick conversion of Indexes and Tables from MS-SQL. /access But for other items I either use the command line or EMS PostgreSQL Manager - This is the favorite tool of the developers I have working on various projects. We develope web applications and applicationsin Delphi, C++ 2. In your organization, do you have someone who works as full time PostgreSQL DBA? No. 3. What is the biggest challenge you have with PostgreSQL? Administration or Programming? My biggest challenge is getting funding to convert other projects completed using MS-SQL to PostgreSQL, but they are coming around. PostgreSQL has been very easy to program and administer. 4. Overall, do you like PostgreSQL? Would you recommend it over MySQL? Coming from a background where data integrity is a high priority as well as performance - it's PostgrSQL hands down. 5. How often do your PostgreSQL run into problem or crash? Are most of the problem caused by PostgreSQL itself? It hasn't for over five years. Any suggestion and help are welcome. Thanks! ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html Tim. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] Are you frustrated with PostgreSQL
On 14 Jul 2003 at 20:55, Ron Johnson wrote: On Mon, 2003-07-14 at 17:44, Dan Langille wrote: On 14 Jul 2003 at 15:16, Terence Chang wrote: Hi all: [snip] Stored procedures is one reason I moved http://www.FreshPorts.org/ from MySQL to PostgreSQL. Oh, the shame! Advertising AOL For Broadband on a FreeBSD ports site? Yep. I'll take money from almost anyone. -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] Are you frustrated with PostgreSQL
1. What is your favorite GUI tool for PostgreSQL? Just psql in an emacs window. Emacs lets me see large result sets, and keep a history of my commands. 2. In your organization, do you have someone who works as full time PostgreSQL DBA? Our Oracle DBA is also the DBA for our production PostgreSQL databases. Developers administer their own databases (some Oracle, some PostgreSQL). 3. What is the biggest challenge you have with PostgreSQL? Administration or Programming? Challenge programming: Familiarity in the group with Oracle makes some tasks quicker in Oracle. Challenge administrating: Remembering when to analyze (especially remembering to stick analyze in the middle of big nightly scripts that make large temporary tables). 4. Overall, do you like PostgreSQL? Would you recommend it over MySQL? Personally I like it a lot. Definately over MySQL, and even over Oracle for anything containing data that don't have complicated replication needs. My DBA, however, prefers Oracle over PostgreSQL. But he doesn't have the budget for Oracle for all our systems. :-) I think he prefers PostgreSQL over MySQL, though. 5. How often do your PostgreSQL run into problem or crash? Are most of the problem caused by PostgreSQL itself? Never had a crash with PostgreSQL itself. One problems with a table where analyze's sampling would generate bad stastics (correlation) for some tables and make the planner pick slow plans. This was worked around by reordering data in the table. Any suggestion and help are welcome. Thanks! One suggestion... if you get a lot of off-the-mailing-list responses, could you post a summary? Ron ---(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