![]() ![]() For example, you may want to index only accounts that are from paying customers, not those created for internal testing: - create index of only paying customersĬREATE INDEX paying_accounts_idx ON accounts (account_id) ![]() A key aspect of partial indexes is that the column being indexed can be different than the ones providing the conditions. ![]() This advantageous feature lets you keep your indexes reasonably sized and targeted to improve performance and reduce size on disk. Partial indexes can be created when you only want to index a subset of a table, such as only rows where a column value meets a particular condition. Let's look at some of these specialized indexes. PostgreSQL supports partial, expression, GiST and GIN indexes, among more standard ones. PostgreSQL offers index capabilities that other open source databases don't have. For this series, we looked at what makes PostgreSQL stand out from other open source SQL databases, namely MySQL, MariaDB and Firebird. In Part II here, we'll look at data manipulation and retrieval, including indexing, virtual table features and query capabilities. PostgreSQL's tag line claims that it's "The world's most advanced open source database." In Part I of this series we looked at storing the data - the model, structures, types and size limits - to give you a few reasons why PostgreSQL makes this claim. What PostgreSQL has over other open source SQL databases: Part II sql postgresql Free 30 Day Trial ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |